SQL Reference

Query databases and work with relational data. Explore 11 entries across 3 categories.

Showing 11 references
Functions

AVG

Returns the average value of a numeric column.

Functions

COUNT

Returns the number of rows.

Statements

DELETE

Removes rows from a table.

Clauses

GROUP BY

Groups rows that have the same values.

Statements

INSERT

Adds new rows to a table.

Clauses

JOIN

Combines rows from two or more tables.

Clauses

ORDER BY

Sorts the result set.

Statements

SELECT

Retrieves data from a database.

Functions

SUM

Returns the total sum of a numeric column.

Statements

UPDATE

Modifies existing rows in a table.

Clauses

WHERE

Filters records based on conditions.