Programming flashcards

SQL Basics: Queries & Joins

Essential SQL concepts for reading data, filtering rows, and joining tables.

10 cards By @mazo

#sql#database#queries#joins

Card preview

Card 1 SELECT

Chooses which columns to return from a table.

Card 2 FROM

Names the table being queried.

Card 3 WHERE

Filters rows by a condition.

Card 4 ORDER BY

Sorts the result set.

Card 5 LIMIT

Restricts the number of returned rows.

Card 6 INNER JOIN

Returns rows with matching values in both joined tables.

Card 7 LEFT JOIN

Returns all rows from the left table plus matching right-table rows.

Card 8 GROUP BY

Groups rows so aggregate functions can summarize them.