III. DMSL | Sorting and Filtering Data

Order By

sorts rows in results for presentation purposes

Order By

guarantees the sort order of the result

Order By

sorts all NULLs together

Order By

Last clause to be logically processed

Order By

it can refer to columns by name, alias

ASC or DESC

Order By declares sort order with ___ or ___

Where

uses predicates

Where

must be expressed as logical conditions

Where

only rows for which predicate evaluates to TRUE are accepted

Where

Values of FALSE or UNKNOWN filtered out

Where

______ clause follows FROM, precedes other clauses

Top

Filtering in the SELECT clause by using the ___ Option

OFFSET-FETCH

Filtering in the ORDER BY clause by using the _____-_____

TOP

allows you to limit the number or percentage of rows returned by a query

TOP

works with ORDER BY clause to limit rows by sort order.

percent

With _____, the number of rows will be rounded up.

with ties

Retrieves duplicates where applicable.

TOP

is proprietary to Microsoft SQL Server

OFFSET-FETCH

is an extension to the ORDER BY clause.

OFFSET-FETCH

it allows filtering a requested range of rows.

OFFSET-FETCH

provides a mechanism for paging through results.

OFFSET-FETCH

specifies number of rows to skip, number of rows to retrieve.

OFFSET-FETCH

This is only available in the SQL Server 2012, 2014 and 2016.

Offset

value must be supplied