SQL Keywords

SELECT

Retrieves data from one or more tables.

FROM

Specifies the table to query.

WHERE

Filters rows that match a condition.

ORDER BY

Sorts the result in ascending or descending order.

GROUP BY

Groups rows with the same values.

HAVING

Filters grouped results after aggregation.

INSERT INTO

Adds new rows to a table.

UPDATE

Modifies existing records.

DELETE

Removes rows from a table.

CREATE TABLE

Creates a new database table.

ALTER TABLE

Changes the structure of a table.

DROP TABLE

Permanently deletes a table.

JOIN

Combines rows from multiple tables.

LEFT JOIN

Returns all rows from the left table and matching rows from the right.

RIGHT JOIN

Returns all rows from the right table and matching rows from the left.

INNER JOIN

Returns only matching rows from both tables.

COUNT()

Returns the number of rows.

SUM()

Calculates the total of numeric values.

AVG()

Calculates the average value.

DISTINCT

Returns unique values only.