Discover published sets by community

Retrieve data from one or more tables.

Modify existing data within a table.

Remove existing data from a table.

Add new data into a table.

Create a new table in the database.

Modify the structure of an existing table.

Delete a table and its data from the database.

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

Filter results of a query based on conditions.

Group rows that have the same values in specified columns.

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

Constrain the number of rows returned by a query.

Filter groups created by GROUP BY based on aggregate conditions.

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

Select records that have matching values in both tables.

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

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

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

Combine the result sets of two or more SELECT statements.

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

Return only distinct (different) values.

Provide conditional logic within SQL queries.

Test for the existence of any record in a subquery.

Count the number of rows that match a specified condition.

Find the smallest value in a column.

Find the largest value in a column.

Calculate the sum of a set of values.

Calculate the average value of a set of values.

Search for a specified pattern in a column.