Question

What will be the output of the following MySQL statement?
SELECT *
FROM employee
WHERE lname LIKE ‘_a%e%’;

Accepted Answer

All of the mentioned

Answer

All employees whose last name start with any letter but second letter should be 'a'

Answer

All employees whose last name start with any letter but contain at least one 'e' in his name

Answer

All employees whose last name should have letter 'a' in second position and at least one 'e' in his name

💬 Discussion

📊 Question Analytics