SQL Commands

Test yourself on SQL with exam style questions, marked instantly.

Flashcards that come back just before you would forget them.

A revision plan that remembers what you know and shows what to do next.

See which topics you have nailed and which need another look.

Quiz yourself on SQLGet your flashcardsBuild my revision planTrack my progress

SQL Commands

Command Purpose Example
SELECT Choose columns to display SELECT name, age
FROM Specify the table FROM Students
WHERE Filter rows by condition WHERE age > 16
ORDER BY Sort results ORDER BY name ASC
AND / OR Multiple conditions WHERE age > 16 AND city = "London"
* (wildcard) Select all columns SELECT *
INSERT INTO (AQA only) Add a new row INSERT INTO Students VALUES (3, 'Sam', 8)
UPDATE ... SET (AQA only) Change values in the rows that match WHERE UPDATE Students SET grade = 9 WHERE name = 'Alex'
DELETE FROM (AQA only) Remove the rows that match WHERE DELETE FROM Students WHERE name = 'Jo'

Make this stick

Signing in gives access to all PrepWise features.

PrepWise is a trading name of A3M Quality Solutions Limited, registered in England and Wales, company number 14959172. Registered office: 202 Stroud Road, Gloucester, GL1 5LA. ICO registration ZC267069.