Discover published sets by community

Sort the results of a query in ascending or descending order.

Filter groups created by GROUP BY based on aggregate conditions.

Select all records when there is a match in either left or right table.

Delete a table and its data from the database.

Find the smallest value in a column.

Combine rows from two or more tables, based on a related column.

Combine the result sets of two or more SELECT statements.

Constrain the number of rows returned by a query.

Select records that have matching values in both tables.

Select all records from the left table, and matched records from the right table.

Specify multiple possible values for a column.

Modify existing data within a table.

Add new data into a table.

Create a new table in the database.

Create an index on one or more columns to improve query performance.

Calculate the sum of a set of values.

Retrieve data from one or more tables.

Modify the structure of an existing table.

Return only distinct (different) values.

Test for the existence of any record in a subquery.

Remove existing data from a table.

Group rows that have the same values in specified columns.

Provide conditional logic within SQL queries.

Filter results of a query based on conditions.

Calculate the average value of a set of values.

Select all records from the right table, and matched records from the left table.

Combine the result sets of two or more SELECT statements, including duplicates.

Find the largest value in a column.

Search for a specified pattern in a column.