CBSE Class 12 Computer Science Question 13 of 78

Simple Queries in SQL — Question 6

Back to all questions
6
Question

Question 6

Write a query to display the name of employee whose name contains 'T' as the last alphabet.

Answer
SELECT ENAME
FROM empl
WHERE ENAME LIKE '%T' ;
Output
+-------+
| ENAME |
+-------+
| SCOTT |
+-------+