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
Write a query to display the name of employee whose name contains 'A' as third alphabet.
Write a query to display the name of employee whose name contains 'T' as the last alphabet.
Write a query on the customers table whose output will exclude all customers with a rating <= 100, unless they are located in Shimla.
Write a query that selects all orders (Order table) except those with zeros or NULLs in the amt field.