CBSE Class 12 Computer Science Question 14 of 78

Simple Queries in SQL — Question 7

Back to all questions
7
Question

Question 7

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

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

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