Document page
Computer Science IGCSEPDF 125
142 pagesrevision 46930
PDF 125
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.
9.1 SQL (Structured Query Language)
●
● Format:
● Example:
❖ SELECT Name, Age
❖ FROM Class
❖ WHERE Age>14
❖ ORDER BY Age DESC;
Itis used to create, update, query, and manage databases.
● Allowing you to extract and update data from database tables.
● You can apply two or more conditions in a WHERE clause using:
❖ SELECT field1, field2, ...
❖ FROM table_name
❖ WHERE condition
❖ ORDER BY field ASC/DESC;
● Note: asc/desc refers to ascending/descending order.
● Note: A semi-colon is necessary to add at the end.
● Note: An order statement is not necessary unless stated. (same
case as with WHERE)
AND (both conditions must be true)
OR (at least one condition must be true)