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 |
+-------+
Get the Bright Tutorials app Stuck on a question? Ask Bright Buddy — your AI tutor — for step-by-step help in the app.