Document page
Computer Science IGCSEPDF 126
142 pagesrevision 46930
PDF 126
Page image rendered from the stored file at 110 dpi; it sharpens as you zoom. Outlines are placed from each region’s stored position on the page (612 × 792 pt).
readable
Source of this text: embedded text layer. The better of the embedded text and OCR is kept.
Examples:
WHERE Class = ‘11B’ AND Age>=16;
WHERE Price < 600 OR Manufacturer = ‘Apple’;
Combination of AND, OR:
WHERE (Job = ‘Manager’ AND City = ‘Lahore’)
OR Salary > 500000;
● Use of SUM and COUNT
● SUM clause adds values, while the COUNT clause numerates items.
● Examples:
SELECT COUNT(Students)
FROM Council
WHERE Marks > 85;
SELECT SUM(Salary)
FROM Employees;
Past Paper Questions: