The following SELECT statement: SELECT EmpFirstName,EmpLastName
FROM tblEmployee
WHERE EmpLastName Like "[D-G]*";
Would list the EmpFirstName and EmpLastName that ________.
A)begins with the letters D,E,F,and G sorted in ascending order
B)begins with the letters D,E,F,and G sorted in descending order
C)begins with the letters D,E,F,and G not sorted in any particular order
D)begins with the letters E and F

Question

Quizplus · Accepted Answer

The statement uses the LIKE operator with a wildcard pattern matching all last names that start from D to G. It selects the EmpFirstName and EmpLastName fields from the tblEmployee table, which lists all employees whose last names begin with D, E, F, or G, sorted in ascending order.

The Following SELECT Statement: SELECT EmpFirstName,EmpLastName