SQL Interview Questions part 12

You can see part 11 here.

166)Display the department name along with total salary in each department.

167) Display itemname and total sales amount for each item.

168) Write a Query To Delete The Repeted Rows from emp table;

169) TO DISPLAY 5 TO 7 ROWS FROM A TABLE

 170)  DISPLAY  TOP N ROWS FROM TABLE?

171) DISPLAY   TOP 3 SALARIES FROM EMP.

172) DISPLAY  9th FROM THE EMP TABLE?

173) Select second max salary from emp;

174) Provide a commission(10% Comm Of Sal) to employees who are not earning any commission.

175) Display those employee whose joining of month and grade is equal.

176) Display the names of the employees who earn highest salary in their respective departments.


 

Questions/Suggestions
Have any question or suggestion for us?Please feel free to post in Q&A Forum
SQL Interview Questions part 11
Shekhar Sharma

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...

2 Responses

  1. kishore says:

    I dont know about this blog before feeling regret that i found late but such a useful blog for ETl testers who wanna build career.Tq once again

Leave a Reply

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