mainframemouli
New User
Joined: 01 Mar 2005 Posts: 52 Location: Mysore
|
|
|
|
4. Display the most recently hired person Department wise.
9. Display the year in which most people joined the co.and the number of people who joined during that period.
10. Display the year during which most people join the co. with their names,dept. num. and avg. salary of their depts.
11. Update the details of King, add Smith's salary to King's and transfer king to the same dept. as that of Allen.
3. Select the names of employees who have number of subordinates.
4. List those employees who have atleast one person reporting to them.
7. List the employees hired in dec.
pls try to write queries for this |
|