Please enable JavaScript.
Coggle requires JavaScript to display documents.
Basic SQL Commands, SELECT - Coggle Diagram
Basic SQL Commands
FROM
Specify table we're pulling from.
WHERE
Filter query to match a condition.
JOIN
Combine rows from 2 or more tables.
AND
Combine query conditions. All must be met.
OR
Combine query conditions. One must be met.
GROUP BY
Group data into logical sets.
ORDER BY
Set order of result. Use DESC to reverse order.
COUNT
Count number of rows.
SUM
Return sum of column.
AVG
Return average of column.
MIN
Return min value of column.
SELECT
Select data from database.