SQL Commands Reference

Part of SQL · Section 3 of 9

DiagramUnit: 3.7 Relational Databases and SQLGCSE

This diagram covers SQL Commands Reference within SQL for GCSE Computer Science. Revise SQL in 3.7 Relational Databases and SQL for GCSE Computer Science with 19 exam-style questions and 10 flashcards. This topic shows up very often in GCSE exams, so students should be able to explain it clearly, not just recognise the term. It is section 3 of 9 in this topic. Focus on the labels, the relationships between parts, and the explanation that turns the diagram into an exam-ready answer.

SQL Commands Reference

SQL commands reference diagram showing the four main SQL operations: SELECT with column list (retrieves data), FROM with table name (specifies the source table), WHERE with condition (filters rows), and ORDER BY with column name ASC or DESC (sorts results), with a complete example query shown: SELECT name, age FROM Students WHERE age greater than 16 ORDER BY name ASC

Practice questions for SQL

Which SQL keyword is used to choose which columns to retrieve from a database table?

  • A. FROM
  • B. WHERE
  • C. SELECT
  • D. ORDER BY
1 markfoundation

Explain the difference between using AND and OR to combine conditions in an SQL WHERE clause. Give an example of when each would be used.

3 marksstandard

Quick recall flashcards

What does WHERE do?
Filters rows based on conditions
What does SELECT do?
Chooses which columns to display

Previous

Talking to Databases

Next

SQL Commands

19 questions on SQL — practise free

Instant marking, adaptive difficulty and spaced-repetition flashcards — all aligned to your exam board.

Start revising free →