1- SELECT
- Select data from database.
2- FROM
- Specify table we're puling from.
3- WHERE
- Filter query to match a condition.
4- AS
- Rename column or table with alias.
5- JOIN
- Combine rows from 2 or more tables.
6- AND
- Combine query conditions. All must be met.
7- OR
- Combine query conditions. One must be met.
8- LIMIT
- Limit rows returned. See also FETCH & TOP.
9- IN
- Specify multiple values when using WHERE.
10- CASE
- Return value on a specified condition.
11- IS NULL
- Return only rows with a NULL In.
12- LIKE
- Search for patterns in column.
13- COMMIT
- Write transaction to database.
14- ROLLBACK
- Undo a transaction block.
15- ALTER TABLE
- Add/Remove columns from table.
16- UPDATE
- Update table data.
17- CREATE
- Create TABLE, DATABASE, INDEX or VIEW.
18- DELETE
- Delete rows from table.
19- INSERT
- Add single row to table.
20- DROP
- Delete TABLE, DATABASE or INDEX.
21- GROUP BY
- Group data into logical sets.
22- ORDER BY
- Set order of result. Use DESC to reverse order.
23- HAVING
- Same as WHERE but filters groups.
24- COUNT
- Count number of rows.
25- SUM
- Return sum of column.
26- AVG
- Return average of column.
27- MIN
- Return min value of column.
28- MAX
- Return max value of column.
Top comments (1)
Thanks very much