Summary IEB IT SQL Statements

Simple SQL Statements
Displaying selected fields: Note:
SELECT <field>, <field> * means all fields
FROM <table>; [] are used if field is
more than one word
Sorting by a field:
SELECT <field (s)> XXX
FROM <table> ASC – Ascending Order
ORDER BY <field> XXX; *default is ASC DESC – Descending Order
Note: You can order by multiple fields!

Displaying data using conditions: #
SELECT * Can be >, < or =
FROM <table> XXX
WHERE <field> # XXX; = ‘Text’
Or can be a digit

Conditions using AND, OR, NOT, BETWEEN … AND …
WHERE Artist = ‘G-Eazy’ AND Title = ‘Scary Nights’;
WHERE Artist = ‘G-Eazy’ OR Artist = ‘NF’;
WHERE NoOfSongs BETWEEN 10 AND 15;

Inserting a record:
INSERT INTO <table> (<field1>, <field2)
VALUES (<value1>, <value2>);

Deleting a record:
DELETE
FROM <table>
WHERE <condition> [AND/OR <condition>]

Changing the details in a field:
UPDATE <table>
SET <column name> = <new value> [,…]
WHERE <column name> = <existing value>

Using quotes in SQL Statements:
Trying to find a name such as O’Brien with an apostrophe in it.
WHERE <name> = ‘O’‘Brien’;

Calculations with fields:
SELECT SSName, SFName, 2015 – AcYear AS [Completion Year]

Deriving a field: (creating a new field using calculations)
SELECT SSName, SFName, 2015 – AcYear AS [Completion Year]




Nikhar Ramlakhan © Page 1 of 5