Discover published sets by community

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

Specifies the table from which to retrieve data.

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.

Sorts the result set in either ascending or descending order.

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

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

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

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

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

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

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

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

Allows you to specify multiple values in a WHERE clause. Works like multiple OR conditions.

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

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

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

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

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