SQL Commands - SELECT Statements

Complete the SELECT Statement

SELECT * _____ ABC

What does ABC in the Select Statement Represent?

SELECT * FROM ABC

• The Name of the Table

• The Name of the Database

• The Name of the Column

What does the * in the Select Statement represent?

SELECT * FROM ABC

• The First Column in the Table

• All the Columns

  in the Table

• The Last Column in the Table

Answer explanation

The asterisk (*) is used widely as a wildcard character in searches

It is used to specify any number of items should go in there

In SQL it means to get all available columns

What goes into the WHERE Clause of a Select Statement?

SELECT * FROM ABC

WHERE _____

• The database that the table is in

• The columns that need to be retrieved

• The condition that the Results must fulfil

Modify the Select Statement to only get the following Columns

Col1, Col2

SELECT * FROM ABC

• SELECT

  Col1 and Col2

  FROM ABC

• SELECT

  Col1 Col2

  FROM ABC

• SELECT

  Col1, Col2, *

  FROM ABC

• SELECT

  Col1, Col2

  FROM ABC

Answer explanation

REMEMBER

Columns need to be separated by commas!

SELECT Name, Phone FROM Contacts

Which is the line that helps us check if the phone number '91234567' is already added?

SELECT Name, Email

FROM Contacts

WHERE Phone = '91234567'

• SELECT Name, Email

• FROM Contacts

• WHERE Phone = '91234567'

Which is the line that tells SQL which table to use?

SELECT Name, Email

FROM Contacts

WHERE Phone = '91234567'

• SELECT Name, Email

• FROM Contacts

• WHERE Phone = '91234567'

Which line do we modify to change the columns we retrieve?

SELECT Name, Email

FROM Contacts

WHERE Phone = '91234567'

• SELECT Name, Email

• FROM Contacts

• WHERE Phone = '91234567'

What happens if we leave out the WHERE part of a SELECT Statement?

SELECT Name, Email

FROM Contacts

WHERE Phone = '91234567' <-

• All the results will display

• All the results will be wrong

• An Error will occur

What happens if we rearrange the Columns in a Select Statement?

SELECT Email, Name <-

FROM Contacts

WHERE Phone = '91234567'

• The columns will not be retrieved

• The columns will be displayed in that order

• An Error will occur