Basic Sql

Front 1

Select all rows in a table 'customers' DB table

Back 1

SELECT * FROM customers;

Front 2

Select columns 'id', 'name', 'start time' from the 'customers' table

Back 2

SELECT id, name, [start time] FROM customers;

or

SELECT id, name, 'start time' FROM customers;

Front 3

Select top 150 records only showing columns 'id' and name from 'customers' table

Back 3

SELECT TOP 150 id, name FROM customers;

Front 4

Select distinct values in the 'city' column of the 'customers'

Back 4

SELECT DISTINCT city FROM customers

Front 5

Select 'id' from the customers able where 'name' is 'Bob Smith'

Back 5

SELECT id FROM customers WHERE name = 'Bob Smith'

Front 6

Name the operators that can be used in where SQL clause

Back 6

=Equal

<> Not equal or != can be used.

> Greater than

< Less than

= Greater than or equal

<= Less than or equal

BETWEEN Between an inclusive range

LIKE Search for a pattern

IN To specify multiple possible values for a column

Front 7

Select all rows from the 'customers' table where the 'country' is 'United Kingdom' and the 'city' is 'London' or 'Cardiff'

Back 7

SELECT * FROM Customers WHERE Country='United Kingdom' AND (City='London' OR City='Cardiff');

Front 8

Select all rows from the 'customers' table where the 'country' is 'United Kingdom' and order by the 'id' column small to larger

And also large ID to small

Back 8

SELECT id, name FROM customers WHERE country = 'United Kingdom' ORDER BY id ASC

for the other way around

ORDER BY id DESC

Front 9

SQl Union what is it

Back 9

It concatinates to datasetse

select id from what

UNION

Select id from what1

Front 10

Back 10

Legend