Sort and filter results in T-SQL

Data Analyst
Data Engineer
Data Scientist
Database Administrator
Solution Architect
Technology Manager
SQL Server
Azure SQL Managed Instance
Azure SQL Server on Virtual Machines
SQL Server on Azure Virtual Machines

Learn how to sort and filter query results

Learning objectives

After completing this module, you will be able to:

  • Sort your results
  • Limit the sorted results
  • Return paged results
  • Remove duplicates
  • Filter data with predicates


Before starting this module, you should be familiar with the basic syntax of the SELECT Transact-SQL statement.