SQL Tutor

Looking for a SQL tutor? Our free online SQL tutorial teaches you SQL. We provide examples of SQL syntax so you can learn SQL quickly. Our SQL tutorial is also a great SQL command reference.

Ordering Rows

Data is stored in Scalable SQL in no particular sequence. If you want to see your data displayed in sequence, you must add an Order By clause to your Select statement.

Syntax:

Select */fieldname<mask> ...
from tablename
order by fieldname;

Explanation:

• The Order By clause tells SQL you want the specified fields displayed in ascending order (ordered from A to Z, 1 to 100).

Retrieve the city, vendor Id, and name from the TrnVendor table. Order your data by city:

1. In the SQL text box type:

Select City, VendId, Name
from TrnVendor
order by City; 

2. Execute the SQL statement.