Ordering, Groups, and Functions

Question 1

ORDER BY

Answer 1

an be added to a query to order the results by the data in a row. The Order by clause is added after WHERE. Results can be ordered in Ascending (ASC) or Descending (DESC) order. The default order is ASC.

Question 2

Limiting Results LIMIT #

Answer 2

clause can be used to limit the number of rows returned. The LIMIT clause is added at the end of the query.