CBSE Class 12 Computer Science Question 5 of 20

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.

Get the Bright Tutorials app Stuck on a question? Ask Bright Buddy — your AI tutor — for step-by-step help in the app.