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
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.