Question

Using the table EMPLOYEE from CARSHOWROOM database, write SQL queries for the following:

1. Display employee name and the last 2 characters of his EmpId.
2. Display designation of employee and the position of character ‘e’ in designation, if present.

Answer 1

a)

SELECT EmpName, RIGHT(EmpId, 2) AS Last2_Characters FROM EMPLOYEE;

b) 

SELECT Designation, INSTR(Designation, 'e') AS Position_of_e FROM EMPLOYEE;

SELECT Designation, CHARINDEX('e', Designation) AS Position_of_e FROM EMPLOYEE;