SQL statements

Data Retrieval
SELECT

Data Manipulation
INSERT
UPDATE
DELETE
MERGE

Data definition
CREATE
ALTER
DROP
RENAME
TRUNCATE

Transactional control
COMMIT
ROLLBACK
SAVEPOINT

Data Control
GRANT
REVOKE

Eliminating Duplicate rows : Use DISTINCT keyword in SELECT command
Limit rows : Use WHERE clause
Display rows in a range of values : Use BETWEEN clause
Test for values in a list :Use IN clause
Perform wildcard searches of valid search string values :Use LIKE clause
Test for nulls :Use IS NULL operator
Sort rows: Use ORDER BY clause ASC or DESC