Basic SQL Statements
| Objective |
SQL Statement |
| List one field. |
SELECT field1 FROM table1 |
| List two fields. |
SELECT field1, field2 FROM table1 |
| Alphabetize (A-Z) |
SELECT field1
FROM table1
ORDER BY field1; |
| Alphabetize (Z-A) |
SELECT field1
FROM table1
ORDER BY field1 DESC;
|
| |