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...
Category: SQL
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 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...
SQL Interview Questions part 5
You can read part 4 here. 61) Display the names of the employees from department number 10 with salary greater than that of all employee working in other departments. 62) Display the names of the...
SQL Interview Questions part 4
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...
SQL Interview Questions part 3
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...
SQL Interview Questions part 2
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...
SQL Interview Questions part 1
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...
SQL Interview Questions
Here , we will cover most common queries/questions asked in SQL interviews. You can also share the questions that you would have faced in interviews , it might be helpful for the someone. You can...
Data Types
What is a Data Type?? A data type is something that assigns some predefined characteristics to the values and tells the SQL engine , what type of value it is and helps to differentiate...