H
hrishi_thematrix
Guest
1.Show the second highest salary in the HR database.
2.Show the name of each department where more than one employee is paid less than 3000.
3.Using self-join,show the last and first names of the employees working in same department as employee ABC
4.Give 10% raise to the employees of theFinance department who make less than 8000.
5.All employees of the 'Marketing Department' are to be moved to the 'Human Resources' department.
2.Show the name of each department where more than one employee is paid less than 3000.
3.Using self-join,show the last and first names of the employees working in same department as employee ABC
4.Give 10% raise to the employees of theFinance department who make less than 8000.
5.All employees of the 'Marketing Department' are to be moved to the 'Human Resources' department.