Studied by 9 people
Looks like no one added any tags here yet for you.
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
