SQL Interview Questions part 8

You can see part 7 here.

106) Display name of those employee who are getting the highest salary?

107) Display those employee whose salary is equal to average of maximum and minimum?

108) Select count of employee in each department  where count greater than 3?

109) Display dname where at least 3 are working and display only department name?

110) Display name of those managers name whose salary is more than average salary of his company?

111)Display those managers name whose salary is more than average salary of his employee?

 112) Display employee name,sal,comm and net pay for those employee whose net pay is greter than or equal to any other employee salary of the company?

113) Display all employees names with total sal of company with each employee name?

114) Find out last 5(least)earners of the company.?

 115) Find out the number of employees whose salary is greater than their manager salary?

116) Display those department where no employee working?

117) Display those employee whose salary is ODD value?

118) Display those employee whose salary contains atleast 3 digits?

119) Display those employee who joined in the company in the month of Dec?

120) Display those employees whose name contains “A”?


 

Questions/Suggestions
Have any question or suggestion for us?Please feel free to post in Q&A Forum
Avatar photo

Shekhar Sharma

Shekhar Sharma is founder of testingpool.com. This website is his window to the world. He believes that ,"Knowledge increases by sharing but not by saving".

You may also like...