Category: SQL Interview Questions

SQL Interview Questions part 9 0

SQL Interview Questions part 9

You can see part 8 here. 121) Display those employee whose deptno is available in salary? 122) Display those employee whose first 2 characters from hiredate -last 2 characters of salary? 123) Display those employee...






SQL interview question part 8 0

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






SQL interview question part 7 0

SQL Interview Questions part 7

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






SQL interview question part 6 0

SQL Interview Questions part 6

You can see part 5 here. 76) Display the following output for each row from emp table. Scott has joined the company on Wednesday 13th August nineteen ninety. [hideshow type=”sql76″]SQL>select ENAME||’ HAS JOINED THE...