Sort and filter results in T-SQL

Beginner
Data Analyst
Data Engineer
Data Scientist
Database Administrator
Developer
Solution Architect
Student
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

Prerequisites

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