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

Worked Examples · Example 9.17

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

Tamil Nadu DgeTextbookSubjective· 2mImportance★★★★★

34% · 32/95 Questions

🔒 Locked · start free trial →

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

Start your 14-day free trial to unlock the full solution →

The pattern '_a%' — one arbitrary character, then 'a', then anything — finds names with 'a' as the second character. On the real EMPLOYEE table this is Aaliya, Sanya, Nachaobi, Daribha and Tanya.

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

On the real EMPLOYEE table (Table 9.8), checking each name's second letter: Aaliya (a ✓), Kritika (r), Shabbir (h), Gurpreet (u), Joseph (o), Sanya (a ✓), Vergese (e), Nachaobi (a ✓), Daribha (a ✓), Tanya (a ✓).

Output

EName
Aaliya
Sanya
Nachaobi
Daribha
Tanya

Start your 14-day free trial to unlock the full solution →

Example 9.17, on the real EMPLOYEE table (Table 9.8): the pattern '_a%' (any one character, then 'a', then anything) matches names whose second character is 'a' — Aaliya, Sanya, Nachaobi, Daribha and Tanya.

The real EMPLOYEE table (Table 9.8)

EmpNo	Ename	Salary	Bonus	DeptId
101	Aaliya	10000	234	D02
102	Kritika	60000	123	D01
103	Shabbir	45000	566	D01
104	Gurpreet	19000	565	D04
105	Joseph	34000	875	D03
106	Sanya	48000	695	D02
107	Vergese	15000	NULL	D01
108	Nachaobi	29000	NULL	D05
109	Daribha	42000	NULL	D04
110	Tanya	50000	467	D05

mysql> SELECT EName FROM EMPLOYEE
    -> WHERE Ename like '_a%';
``` …

Start your 14-day free trial to unlock the full solution →

←Previous question · 9.6.2Example 9.16 — The following query selects names of all employees containing 'se' as …→Next question · 9.6.2Activity 9.8 — Compare the output produced by the query in Example 9.6 and the output…

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

Concept understanding — Set Difference

The real EMPLOYEE table (Table 9.8)

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

The real EMPLOYEE table (Table 9.8)

🎓Unlock everything free for 14 days

Unlock everything free for 14 days