This documents contains all the commands that you will come across in Delphi for Grade 11 -12 SQL.
There are 7 NSC exam questions included for you to downloaded (link in the document). These questions include the working files for you to practice, the solutions and additional notes where needed....
SQL Description Usage
SELECT Used to select data from a database SELECT * FROM tblTowns
SELECT * FROM tblTowns
WHERE Used to specify a filter WHERE Population > 1000
SELECT MAX(Population)
as HighestPopulation
AS Used to assign a name to a column from tblTowns;
SELECT * FROM tblTowns
WHERE Province LIKE
LIKE Used to search for a pattern 'G%';
SELECT * FROM tblTowns
WHERE Province IN
('Gauteng','Eastern
IN Used to specify multiple values Cape') ;
SELECT * FROM tblTowns
BETWEEN Used to select a given range WHERE Population BETWEEN
SELECT * FROM tblTowns
ORDER BY Used to sort data in ascending or descending ORDER BY TownName;
SELECT Province, COUNT
(*) AS CriticalTowns
GROUP BY Used in conjuntion with Aggregate Functions to group data FROM
tblTowns WHERE WaterRe-
strictions = TRUE GROUP
BY Province;
INSERT INTO tblGames
VALUES (76,
#2017/12/24#, "HM008",
INSERT INTO Inserts data from a table 250, 5566);
UPDATE tblTowns SET Wa-
terRestrictions = True
WHERE Province = "North
UPDATE Updates data from in a table West";
DELETE FROM tblDams
DELETE Delete data from a table WHERE HeightOfWall <
SELECT Count(Population)
COUNT Return the number of occurences FROM tblTowns;
SELECT MIN(Population)
MIN Returns smallest value of a column from tblTowns;
SELECT MAX(Population)
MAX Returns highest value of a column from tblTowns;
SELECT AVG(Population)
AVG Returns the average of a column from tblTowns;
SELECT SUM(Population)
SUM Returns the total of a column from tblTowns;
NOW Returns current date and time SELECT NOW();
SELECT DAY(#2019-01-
DAY Returns day of month for a given date 23#);
SELECT MONTH(#2011-02-
MONTH Returns the month part of a date 14#);
SELECT YEAR(#2015-04-
YEAR Returns the year part of a date 14#);
SELECT ROUND(123.321,
ROUND Rounds a number to a specific number of decimal places 2);
Rounds a number to a specific number of decimal places, re- SELECT FORMAT
FORMAT turns string (48934892.34893, 3);
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through EFT, credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying this summary from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller StudyWellNotes. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy this summary for R50,00. You're not tied to anything after your purchase.
