Limiting Rows Using a Selection




Restrict the rows that are returned by using the WHERE clause:


Using the WHERE Clause

Character Strings and Dates

Comparison Conditions


Logical Conditions


Rules of Precedence

Using the ORDER BY Clause

Sort retrieved rows with the ORDER BY clause:

– ASC: ascending order, default 
– DESC: descending order 

 The ORDER BY clause comes last in the SELECT statement: