Sql

Front 1

What is the term SQL short for?

Back 1

Structured Query Language

Front 2

What is the SELECT statement used for?

Back 2

Selecting data from a SQL database table.

Front 3

What happends when you put(*) after the SELECT statement?

Back 3

It selects all data from the chosen table.

Front 4

The SELECT INTO statement is used to?

Back 4

To select data from a table and insert it into another table at the same time.

Front 5

What does the DISTINCT clause do?

Back 5

Used together with the SELECT keyword it returns a dataset with unique entries for certain database table column.

Front 6

What is the WHERE clause used for?

Back 6

Used to select data conditionally, by adding it to already existing SQL SELECT query.

Front 7

What will be the result of the following query?
SELECT LastName, FirstName
FROM Students
WHERE gender = 'Male'
ODER BY LastName ASC

Back 7

Selects the Last and first name of all male students from the table 'Students' in ascending order by Last name.

Front 8

What does this do?:
SELECT count(*)
FROM Scores
WHERE score > 5

Back 8

It counts how many records have a score higher than 5 from the table Scores

Front 9

What is the SQL AVG syntax?

Back 9

SELECT AVG(Column1)
FROM Table1

Front 10

When is the SQL AND clause used?

Back 10

Is used when you want to specify more than one condition in your SQL WHERE clause, and at the same time you want all conditions to be true.