The following query displays names of all the employees containing 'se' as a substring in name.

Worked Examples · Example 8.16

Q. The following query displays names of all the employees containing 'se' as a substring in name.

West Bengal WbchseTextbookSubjective· 2mImportance★★★★★

56% · 25/45 Questions

You're viewing a preview — the full solution, concept, methods & PYQ mapping are locked.

Employees whose name contains 'se' as a substring.

SELECT Ename FROM EMPLOYEE WHERE Ename LIKE '%se%';

Output:

+---------+
| Ename   |
+---------+
| Joseph  |
| Vergese | …

Employees whose name contains 'se' as a substring.

SELECT Ename FROM EMPLOYEE WHERE Ename LIKE '%se%';

Output:

+---------+
| Ename   |
+---------+
| Joseph  |
| Vergese | …

Q.The following query displays names of all the employees containing 'se' as a substring in name.