When you retrieve data from a database, you will often want to sort the data into a particular order, or filter it to include only the rows that meet specific criteria.

The Transact-SQL SELECT statement supports sorting query results by applying the ORDER BY clause, and filtering results using the WHERE clause.

In this module, you will learn how to:

  • Sort the results of a query by using the ORDER BY clause
  • Limit the sorted results to show only the top n rows
  • Return paged results
  • Remove duplicates from results
  • Filter data with predicates in the WHERE clause