Discover published sets by community

Specifies the table from which to retrieve data.

Used in a WHERE clause to test for the existence of any record in a subquery.

Filters the data returned by a SQL query, based on a specified condition.

Combines rows from two or more tables, based on a related column between them.

Used instead of WHERE with aggregate functions. Filters the data after the aggregation.

Operator used in a WHERE clause to search for a specified pattern in a column.

Used to rename a column or table with an alias. This alias is used to make column names more readable.

Restricts the number of rows returned by a query. Useful in pagination.

Used with SELECT to remove duplicate rows in the result set. Only distinct (different) values are selected.

Logical operator that combines two or more conditions in a WHERE clause, all conditions must be true.

Similar to UNION, but includes duplicates. Combines the result-sets of multiple SELECT statements.

Operator selecting values within a range, used in WHERE clause. The range includes the endpoints.

Arranges identical data into summary rows. Typically used with aggregate functions (COUNT, MAX, MIN, SUM, AVG).

Logical operator used to negate a condition in a WHERE clause.

Sorts the result set in either ascending or descending order.

Combines the result-set of two or more SELECT statements, only includes distinct values.

Logical operator that combines two or more conditions in a WHERE clause, at least one condition must be true.

Used to create conditional logic within a SQL query. Functions like an if-then-else statement.

Used to retrieve data from a database. It specifies the columns to be returned in the result set.