SQL ORDER BY Statement:
(1) “ORDER BY” statement used for sorting records in the table from the database.
(2) Syntax of “ORDER BY” statement is:
| SELECT DISTINCT column1, column2, … FROM table_name ORDER BY Col1, Col2….; |
(3) Let’s take an example to sort records according to the “Address” column in the “Vendor table”.
(4) Select the database in the SQL server and click on the “New Query” button as shown.
(5) After that new query editor open as shown.
(6) After doing the above steps, write the query in the editor, as shown.
Source Code:
| –// Without “ORDER BY” condition in “Address” column in Vendor table Select [No_],[Name],[Address] from dbo.[CRONUS India Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] –// Without “ORDER BY” condition in “Country_Region Code” column in Vendor table –// With “ORDER BY” condition in “Address” column in Vendor table Select [No_],[Name],[Address]from dbo.[CRONUS India Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] Order By [Address] –// With “ORDER BY” condition in “Country_Region Code” column in Vendor table |
(7) After writing the query, then execute the query (Shortcut keys is F5) as shown.
(8) After executing the two queries in the same editor, SQL gives two results. Note: Recommended write and execute query one by one for reporting.
