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 progressSQL 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.