-
MODULES
11-
Introduction to Microsoft SQL Server 2016 30 minLecture1.1
-
Introduction to T-SQL Querying 30 minLecture1.2
-
Writing SELECT Queries 30 minLecture1.3
-
Querying Multiple Tables 30 minLecture1.4
-
Sorting and Filtering Data 30 minLecture1.5
-
Working with SQL Server 2016 Data Types 30 minLecture1.6
-
Using DML to Modify Data 30 minLecture1.7
-
Using Built-In Functions 30 minLecture1.8
-
Grouping and Aggregating Data 30 minLecture1.9
-
Using Subqueries 30 minLecture1.10
-
Using Set Operators 30 minLecture1.11
-
Sorting and Filtering Data
This module explains how to enhance queries to limit the rows they return, and to control the order in which the rows are displayed. The module also discusses how to resolve missing and unknown results.
Lessons
- Sorting Data
- Filtering Data with Predicates
- Filtering with the TOP and OFFSET-FETCH Options
- Working with Unknown Values
Lab : Sorting and Filtering Data
After completing this module, you will be able to:
- Filter data with predicates in the WHERE clause.
- Sort data using ORDER BY.
- Filter data in the SELECT clause with TOP.
- Filter data with OFFSET and FETCH.