CBSE Class 12 Computer Science Question 4 of 20

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