Discover published sets by community

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.

Modify existing data within a table.

Create a new table in the database.

Constrain the number of rows returned by a query.

Retrieve data from one or more tables.

Add new data into a table.

Remove existing data from a 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.

Calculate the average value of a set of values.

Test for the existence of any record in a subquery.

Search for a specified pattern in a column.

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

Return only distinct (different) values.

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

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

Modify the structure of an existing table.

Filter results of a query based on conditions.

Provide conditional logic within SQL queries.

Find the smallest value in a column.

Delete a table and its data from the database.

Count the number of rows that match a specified condition.

Group rows that have the same values in specified columns.

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

Calculate the sum of a set of values.

Specify multiple possible values for a column.

Filter groups created by GROUP BY based on aggregate conditions.

Select records that have matching values in both tables.