Sort your results
It returns the results of a query in a particular order
What is the SORT clause?
it will let you specify how many rows to return, either as an integer or as a percentage
what is the TOP clause?
This extension to the ORDER BY clause adds the ability to supply a starting point and a value to specify how many rows to return
What is OFFSET-FETCH?
By default, the SELECT clause includes this implicit keyword that results in a complete list of data as output
What is the ALL keyword?
This clause is made up of one or more search conditions, each of which must evaluate to TRUE, FALSE, or 'unknown'
What is the WHERE clause?
In the logical order of query processing, it is the last phase of a SELECT statement to be executed.
what is the ORDER BY clause?
Can be used with or without ORDER BY and with a constant or a variable
What is the TOP clause?
The starting point for "page-at-a-time" results
What is OFFSET?
Used to avoid returning non-unique rows
What is the DISTINCT keyword?
Filter to exclude the unknown.
What is IS NOT NULL
DESC
what is Descending?
Returns a percentage of eligible rows
What is the PERCENT clause?
It determines how many rows to return for "page-at-a-time" results.
What is FETCH?
It is included, by default, in a SELECT statement
What is an implicit ALL?
These operators are processed before OR operators
What are AND operators?
The default sort direction
what is Ascending?
Return all rows that qualify for the top 10: SELECT TOP 10 ________ Name, Price
FROM Production.Product
ORDER BY Price
What is WITH TIES?
SELECT ProductID, ProductName, ListPrice
FROM Production.Product
ORDER BY ListPrice DESC
____?_____ ROWS --Skip 20 rows
What is OFFSET 20?
To return only unique rows:
SELECT ______ City, St FROM Prod.Supplier
ORDER BY St, City
What is the DISTINCT keyword?
Includes IN, BETWEEN and LIKE
What are comparison operators?
ASC
who is the American Society of Cinematographers?
How about this "@x"?
DECLARE @x
SELECT TOP(@x) Name, Price...
What is a variable?
SELECT ProductID, ProductName, ListPrice
FROM Production.Product
ORDER BY ListPrice DESC
OFFSET 25 ROWS --Skip 25 rows
_____?_____ ROWS ONLY; --Get the next 30
What is FETCH NEXT 30?
Returns two of each unique value in SELECT
What is NOT the DISTINCT keyword?
Can be used in place of this:
WHERE num = 2 OR num = 3 OR num = 4
What is WHERE num IN (2, 3, 4)