KwickClips Databases and SQL · 45 sec · free
Which keyword sorts largest first?
Short answer. DESC.
Which one counts records?
COUNT.
Remember
| DESC: largest first |
| SUM adds, COUNT counts |
Six SQL words cover most exam questions. Ready? Select picks fields. From names the table. Where filters records. Order by sorts. Sum adds, and count counts. Two tips. Descending is largest first. Sum adds, count counts.
This clip is from the full lesson: SQL for Cambridge IGCSE: Single-table Databases and Queries — 8 minutes, with the tables, the quick answers and the whole lesson in text.
Useful for: Cambridge IGCSE Grade 9 Computer Science (0478), Cambridge IGCSE Grade 9 Computer Science (0478), Cambridge IGCSE Grade 9 Computer Science (0478), Cambridge IGCSE Grade 10 Computer Science (0478)
More KwickClips from this lesson
What is a record?40 sec
Why do marks get lost?42 sec
What is the difference between validation and verification?41 secVoice-over is AI-generated; the script is written and checked by Kajal Ma'am. Confirm anything you plan around against your official board document. We never ask for a password or an OTP.