The following query displays names of all employees containing 'a' as the second character.

Worked Examples · Example 8.17

Q. The following query displays names of all employees containing 'a' as the second character.

Telangana TsbieTextbookSubjective· 2mImportance★★★★★

58% · 26/45 Questions

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

Employees whose name has 'a' as the second character.

SELECT EName FROM EMPLOYEE WHERE Ename LIKE '_a%';

Output:

+----------+
| EName    |
+----------+
| Aaliya   |
| Sanya    |
| Nachaobi |
| Daribha  |
| Tanya    |
+----------+ …

Employees whose name has 'a' as the second character.

SELECT EName FROM EMPLOYEE WHERE Ename LIKE '_a%';

Output:

+----------+
| EName    |
+----------+
| Aaliya   |
| Sanya    |
| Nachaobi |
| Daribha  |
| Tanya    |
+----------+ …

Q.The following query displays names of all employees containing 'a' as the second character.