Computer Science

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

SQL Queries

12 Likes

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.

Answered By

6 Likes


Related Questions