Tag: databases

SELECT * FROM Persons WHERE FirstName='Peter',LastName='Jackson'

SELECT * FROM Persons WHERE FirstName='Peter' OR LastName='Jackson'

SELECT * FROM Persons WHERE FirstName='Peter' AND LastName='Jackson'

SELECT * FROM Persons WHERE FirstName<>'Peter' AND LastName<>'Jackson'

SELECT * FROM Persons ORDER BY FirstName DESC

SELECT * FROM Persons SORT BY 'FirstName' DESC

SELECT * FROM Persons SORT 'FirstName' DESC

SELECT * FROM Persons ORDER FirstName DESC

SELECT DIFFERENT

SELECT DISTINCT

SELECT COUNT

SELECT UNIQUE

you save and close the file

you save excel in XML format

you create an excel template

you save it in Excel 2007 version

An entire column gets selected in MS Excel

The entire worksheet gets selected in MS Excel

An entire row gets selected in MS Excel

Nothing happens

Column

123_Invoices

Catch_#22

#Invoices

None of the above

2%

20%

25%

200%

Shift + F1

Ctrl + 1

F11 or ALT+F1

Ctrl + Shift + F1

The cell gets formatted to Number category with 2 decimal places

The cell gets formatted to Number category with 4 decimal places

The cell gets formatted into different font

Nothing happens

True

False