by Editorial | Aug 22, 2026 | Grade 11 - SQL, Grade 12 - SQL
It is easy to think that a database has some sort of logic, intelligence and self-awareness. It is does not. A database is like a suitcase of clothes. Some items “go with” other items but the clothes themselves do not understand their relationship with one...
by Editorial | Aug 21, 2026 | Grade 12 - SQL
Random numbers with predictable starting and ending values eg 1 – 10, 1 – 100, 1 -1000In SQL we use the RND( ) function. Inside the round brackets goes the seed value (an integer value) Generating a random number requires a few steps. A) Generating a...
by Editorial | Aug 19, 2026 | Grade 12 - SQL
In grade 12 you need to be familiar with composite SQL statements (embedded / nested SQL statements). This means that two statements are joined together – the result set on one query is passed to the other. Therefore there are two SELECT / FROM statements joined...
by Editorial | Mar 4, 2025 | Grade 12 - SQL, PWC grade 12 - All
SQL summary cheat sheet version 15 Click here SQL summary cheat sheet. Author unknown. Click here SQL summary cheat sheet version 6. Advanced. Embedded queries Click here...
by Editorial | Mar 3, 2025 | Grade 11, Grade 11 - SQL, Grade 12, Grade 12 - SQL
SQL TIPS for exams. STUDY the database first (at least 5 full minutes). Study both the data and the fields. Know how many records are in each table so that you can recognize any potential errors in the returned dataset. The better you understand the database, the...
by Editorial | Aug 22, 2022 | Grade 12, Grade 12 - SQL
Here is a SQL exercise based on the 2022 SQL exam set by Dr C Kader and moderated by Mr T de Jager and Mr R Viljoen of the IEB Pretoria 480 cluster. In some cases you may find comments which can be annoying if you print the documents shown below. These can be turning...
