Write a query to display the connection name ,from_unit and to_unit and rate of all the slabs.Display the records in ascending order based on connection_name.

Sure, here is a SQL query that should give you the desired result:

SELECT connection_name, from_unit, to_unit, rate
FROM slabs
ORDER BY connection_name ASC;

Here's a step-by-step breakdown of the query:

1. SELECT connection_name, from_unit, to_unit, rate: This part of the query is selecting the columns that you want to display in your final result. In this case, you want to display the connection_name, from_unit, to_unit, and rate columns.

2. FROM slabs: This part of the query is specifying the table that you want to select the data from. In this case, you're selecting data from the slabs table.

3. ORDER BY connection_name ASC: This part of the query is ordering the results in ascending order based on the connection_name column. ASC stands for ascending. If you wanted to order the results in descending order, you would use DESC instead.