The following query displays details of all those employees whose name starts with 'K'.

Worked Examples · Example 8.13

Q. The following query displays details of all those employees whose name starts with 'K'.

Odisha ChseTextbookSubjective· 2mImportance★★★★★

49% · 22/45 Questions

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

Employees whose name starts with 'K'.

SELECT * FROM EMPLOYEE WHERE Ename LIKE 'K%';

Output:

+-------+---------+--------+-------+--------+
| EmpNo | Ename   | Salary | Bonus | DeptId |
+-------+---------+--------+-------+--------+ …

Employees whose name starts with 'K'.

SELECT * FROM EMPLOYEE WHERE Ename LIKE 'K%';

Output:

+-------+---------+--------+-------+--------+
| EmpNo | Ename   | Salary | Bonus | DeptId |
+-------+---------+--------+-------+--------+ …

Q.The following query displays details of all those employees whose name starts with 'K'.