SQL Basics

SQL statement

SQL verbs

VERB	Description
SELECT	Retrieve data from a table
INSERT	Adds data into a table
DELETE	Remove data from a table
UPDATE	Modify data in a table
DROP	Delete a table
UNION	Combine output from multiple queries
WHERE	Filter records based on the conditions
AND/OR/NOT	Filter records based on logical conditions
ORDER BY	Sort records in ascending or descending order

SQL Special Characters

Special Character	Description
' and "	String delimiters
--, /*, #	Comment delimiters
*, %	Wildcards
;	End SQL statement
=, +, <, >, ()	Logical operations