SQL SERVER Keywords

LIKE (def'n)

This allows you to specify a pattern to match records in your where clause.
VIEW (def'n)

This a virtual table, which is a result of a query. They can be used to create virtual tables of complex queries.
DISTINCT (def'n)

Return unique results
JOIN (def'n)

This clause combines columns from one or more tables in a relational database.

It creates a set that can be saved as a table or used as it is.
LEFT OUTER JOIN (def'n)

Join where all rows from table A (left operand) are returned,even if they do not exist in table B (right operand)
RIGHT OUTER JOIN (def'n)

Join where all rows from table B (right operand),even if they do not exist in table A (left operand)
INNER JOIN (def'n)

Join that will fetch the results that exist in both tables no null returns.
IN (a, b, c) (def'n)

check if the value is contained among given
COUNT (def'n)

return the number of rows
SUM (def'n)

Use to cumulate the values
AVE (def'n)

return the average for the group
MIN / MAX (def'n)

return the smallest / largest value
GROUP BY (def'n)

This part of the query will aggregate the data
HAVING count(*) > 1 (def'n)

This part of the query limits aggregated data used with GROUP BY
ORDER BY col (def'n)

order of the results by a column (or columns)

Author

geschw66

335469

Card Set

SQL SERVER Keywords

Description

SQL Server keywords with short definition

Updated

2017-10-26T23:49:07Z

Show Answers