Click on the SQL tutorial sections below to be taken to a SQL tutorial with an interactive demo of that concept!
Retrieves data from a database.
Retrieves unique data from a database.
Filters data based on a condition.
Sorts the retrieved data.
Groups rows that have the same values.
Filters groups based on a condition.
Counts the number of rows.
Calculates the total sum of a numeric column.
Calculates the average value of a numeric column.
Finds the smallest value in a column.
Finds the largest value in a column.
Combines rows from two or more tables.
Returns rows when there is at least one match in both tables.
Returns all rows from the left table and matched rows from the right table.
Returns all rows from the right table and matched rows from the left table.
Returns rows when there is a match in one of the tables.
Combines the result-set of two or more SELECT statements.
Provides if-then-else logic in SQL.
Searches for a specified pattern in a column.
Allows specifying multiple values in a WHERE clause.
Filters values within a specified range.
Renames a table or a column for the purpose of a query.
Limits the number of rows returned in a query result.
A query nested inside another query.
A subquery that depends on the outer query for its values.
Functions used to manipulate strings.
Functions used to manipulate dates.
Converts data from one type to another.
Returns the first non-null value in a list.
Functions that handle NULL values.
Provides aggregate calculations across a set of table rows.
Rotates table data to and from summary rows to columns.
Defines a temporary result set that you can reference within a SELECT, INSERT, UPDATE, or DELETE statement.
