SQL SERVER Keywords

Home > Preview

The flashcards below were created by user geschw66 on FreezingBlue Flashcards.


  1. LIKE (def'n)
    This allows you to specify a pattern to match records in your where clause.
  2. 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.
  3. DISTINCT (def'n)
    Return unique results
  4. 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.
  5. 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)
  6. 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)
  7. INNER JOIN (def'n)
    Join that will fetch the results that exist in both tables no null returns.
  8. IN (a, b, c) (def'n)
    check if the value is contained among given
  9. COUNT (def'n)
    return the number of rows
  10. SUM (def'n)
    Use to cumulate the values
  11. AVE (def'n)
    return the average for the group
  12. MIN / MAX (def'n)
    return the smallest / largest value
  13. GROUP BY (def'n)
    This part of the query will aggregate the data
  14. HAVING count(*) > 1 (def'n)
    This part of the query limits aggregated data used with GROUP BY
  15. ORDER BY col (def'n)
    order of the results by a column (or columns)

Card Set Information

Author:
geschw66
ID:
335469
Filename:
SQL SERVER Keywords
Updated:
2017-10-26 23:49:07
Tags:
SQL SERVER
Folders:

Description:
SQL Server keywords with short definition
Show Answers:

Home > Flashcards > Print Preview