SQL

SQL

Structured Query Language

Static Query Language

Structure Query Language

To communicate with a game

To communicate with aliens

To communicate with a database

To communicate with a base

It is used to select a database

It is used to select data from a database

It is used to select a website

It is not a SQL statement

It is used to select a database

It is not a SQL statement

It is used to select a website

It is used to specify which table to select data from.

It would display pupils who have a * in their name.

It is not a SQL statement.

It would display all records from the Pupils table.

It would not display any pupils.

It would only display pupils forename and surname from the Pupils table.

It is not a SQL statement.

It would display all pupils forenames from Pupils table.

It would not display any pupils.

SELECT * FROM Pupils

SELECT * FROM Pupils WHERE surname, regiClass

SELECT surname, regiClass

SELECT surname, regiClass FROM Pupils

SELECT surname FROM Pupils WHERE Smith

SELECT * FROM Pupils WHERE surname = Smith

SELECT * FROM Pupils WHERE surname = "Smith"

SELECT * FROM Pupils

SELECT * FROM Pupils WHERE age > 12

SELECT * FROM Pupils WHERE age < 12

SELECT * FROM Pupils WHERE age > "12"

SELECT * FROM Pupils WHERE age >= 12

SELECT * FROM Pupils WHERE Age >= 12 AND Surname = "Smith"

SELECT * FROM Pupils WHERE Age >= 12 AND Surname = Smith

SELECT * FROM Pupils WHERE Age > 12 AND Surname = "Smith"

SELECT * FROM Pupils