CBSE Class 12 Computer Science Question 12 of 78

Simple Queries in SQL — Question 5

Back to all questions
5
Question

Question 5

Write a query to display the name of employee whose name contains 'A' as third alphabet.

Answer
SELECT ENAME
FROM empl
WHERE ENAME LIKE '__A%' ;
Explanation

There are no employees whose name contains 'A' as the third alphabet in the empl table. Therefore, the output will be empty.