SELECT Queries
5 commands available
Basic SELECT
Retrieve data from a table
beginnercommon
SELECT DISTINCT
Remove duplicate results
beginnercommon
INNER JOIN
Show matching records in both tables
intermediatecommon
LEFT JOIN
Show all records from left table and matching records from right
intermediatecommon
Subqueries
Query within another query
advancedoccasional