Computer Science
Write a query to display the name of employee whose name contains 'T' as the last alphabet.
SQL Queries
9 Likes
Answer
SELECT ENAME
FROM empl
WHERE ENAME LIKE '%T' ;
Output
+-------+
| ENAME |
+-------+
| SCOTT |
+-------+
Answered By
4 Likes
Related Questions
Write a query to display the name, job title and salary of employee who do not have manager.
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 'M' as first alphabet 'L' as third alphabet.
Write a query on the customers table whose output will exclude all customers with a rating <= 100, unless they are located in Shimla.