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
Print Friendly, PDF & Email
SQL Interview Questions part 7
SQL Interview Questions part 9
Shekhar Sharma

Shekhar Sharma

Shekhar Sharma is founder of testingpool.com. He is an automation engineer having more than 8 years of experience who loves troubleshooting in automation and finding innovative ways to solve the problems. His other leisurely activities includes playing harmonica, paintings, sketching portrait, watching movies and travelling etc.

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *