Which one of the following SQL commands is executed to display all the records having a second letter in the LNAME (LAS T NAME) as "A" from the…
Class 12 Computer Science · 2079 · Solved Question with Answer
Which one of the following SQL commands is executed to display all the records having a second letter in the LNAME (LAST NAME) as "A" from the customer table?
A) SELECT * FROM CUSTOMER WHERE LNAME LIKE "?A%";
B) SELECT * FROM CUSTOMER WHERE LNAME LIKE "_A%";
C) SELECT * FROM CUSTOMER WHERE LNAME LIKE "A%";
D) SELECT * FROM CUSTOMER WHERE LNAME LIKE "%A";