SQL Cheat Sheet - CS 4720
[Pages:1]SQL Cheat Sheet
Statement
Syntax
Quick Description
SELECT
SELECT [ DISTINCT ] * | LIST OF COLUMNS, FUNCTIONS, CONSTANTS FROM LIST OF TABLES OR VIEWS [ WHERE CONDITION(S) [AND|OR|NOT] ] [ ORDER BY ORDERING COLUMN(S) [ ASC | DESC ] ] [ GROUP BY GROUPING COLUMN(S) ] [ HAVING CONDITION(S) ]
Query a set of records. Equivalent to A1, A2... An ( P (r1 x r2 x ... rn) ) and returns a relation. SELECT * FROM r1, r2 is Cartesian Product Functions allowed: SUM, AVG, MIN, MAX, COUNT DISTINCT removes duplicates NOTE: ALL QUOTES AROUND STRINGS ARE SINGLE QUOTES! To reference a column in a specific relation, use TABLE.COLUMN_NAME
WHERE
...WHERE COLUMN OPERATOR VALUE
Set comparisons: ...WHERE COLUMN OPERATOR ALL | SOME ...WHERE [NOT] EXISTS RELATION ...WHERE [NOT] UNIQUE RELATION
Operators: =, (not equal), >, >=, ................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- oracle pl sql quick reference university of manitoba
- oracle database sql language quick reference
- sql plus quick reference oracle
- oracle sql reference cheat sheet
- mysql cheat sheet websitesetup
- sql cheat sheet cs 4720
- letter standard sql functions cheat sheet
- sql quick guide tutorialspoint
- sql server quick guide basic syntax and examples for the
- string functions control flow functions cheat sheet
Related searches
- cheat sheet for word brain game
- macro cheat sheet pdf
- logarithm cheat sheet pdf
- excel formula cheat sheet pdf
- excel formulas cheat sheet pdf
- excel cheat sheet 2016 pdf
- vba programming cheat sheet pdf
- macro cheat sheet food
- free excel cheat sheet download
- onenote cheat sheet pdf
- punctuation rules cheat sheet pdf
- excel formula cheat sheet printable