Free CompTIA ITF+ FC0-U61 Practice Question
Which query would efficiently retrieve the first name and last name of all employees in the 'Staff' table whose last name begins with the letter 'S' and are sorted in ascending order by their first name?
SELECT FirstName, LastName FROM Staff WHERE LastName LIKE 'S%' ORDER BY FirstName DESC;
SELECT * FROM Staff WHERE LastName = 'S*';
SELECT FirstName, LastName FROM Staff WHERE LastName LIKE 'S%' ORDER BY FirstName ASC;
SELECT FirstName, Surname FROM Staff WHERE Surname LIKE 'S%';
This question's topic:
CompTIA ITF+ FC0-U61 /
Database Fundamentals
SAVE $17