CompTIA Study Materials
AWS Study Materials
AWS Cloud Practitioner AWS Cloud Practitioner
AWS Cloud Practitioner CLF-C02
Microsoft Study Materials
Microsoft Azure Fundamentals Microsoft Azure Fundamentals
Microsoft Azure Fundamentals AZ-900

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 FirstName, LastName FROM Staff WHERE LastName LIKE 'S%' ORDER BY FirstName ASC;

  • SELECT * FROM Staff WHERE LastName = 'S*';

  • SELECT FirstName, Surname FROM Staff WHERE Surname LIKE 'S%';

Subscribe to avoid duplicate questions and track your progress over time
This question is for objective:
Database Fundamentals
Your Score:
Database Fundamentals
Infrastructure
Applications and Software
Software Development Concepts
Security
IT Concepts and Terminology