A database table is defined as students(roll_no, name, city). Which of the following SQL queries correctly lists the names of all students whose name BEGINS with the letter A?
SELECT name FROM students WHERE name LIKE 'A%';
SELECT name FROM students WHERE name LIKE '%A';
SELECT name FROM students WHERE name = 'A%';
SELECT name FROM students WHERE name LIKE '_A';
The verified answer and full solution are one login away
Every answer here is machine verified, with a step-by-step solution that teaches the method. Your login also unlocks a 7-question mock preview in the real exam interface.
Log in to see the answerMore sql questions