Which of the following SQL WHERE clauses will select all students whose last name begins with "S"?
A) Where LastName Like "S%"
B) Where LastName Like "S"
C) Where LastName = "S%"
D) Where LastName = "S*"

Question

Quizplus · Accepted Answer

The % symbol in SQL is known as the wildcard character, which represents one or more characters. So, "S%" means that the last name should start with "S" followed by zero or more characters.

Which of the Following SQL WHERE Clauses Will Select All