Computer Science

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

SQL Queries

2 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

2 Likes


Related Questions