Tagged: SQL Interview Question

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

You can see part 10 here. 151) My boss has changed his mind.  Now he doesn’t want to pay more than 10,000.so revoke that salary constraint. 152) Add column called as mgr to your emp...

You can see part 9 here. 136) Display the 10th record of emp table without using group by and rowid?  137) Delete the 10th record of emp table; 138) Create a copy of emp table;...

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

You can see part 6 here. 91) Display ename who are working in sales dept. 92) Display employee name,deptname,salary and comm for those sal in between 2000 to 5000 while location is Chicago. 93)Display those employees...

You can see Part 3 here. 46) Display the various jobs and total salary for each job. 47) Display the various jobs and total salary for each job. 48) Display the depart numbers with...

You can see Part 2 here. 31) Display the maximum salary being paid to CLERK. 32) Display the maximum salary being paid to depart number 20. 33) Display the minimum salary being paid to...

You can see Part 1 here. 16) Display the names of all tables from current user. 17) Display the name of the current user. 18) Display the names of employees working in depart number...

The queries which we are going to share here, have mostly been asked in interviews. This is SQL interview questions  part 1. 1) Display the details of all employees. 2) Display the department information from...