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 department table.
3) Display the name and job for all the employees.
4) Display the name and salary for all the employees.
5) Display the employee no and total salary for all the employees.
6) Display the employee name and annual salary for all employees.
7) Display the names of all the employees who are working in depart number 10.
8) Display the names of all the employees who are working as clerks and drawing a salary more than 3000.
9) Display the employee number and name who are earning commissions.
10) Display the employee number and name who do not earn any commissions
11) Display the names of employees who are working as clerks, salesman or analyst and drawing a salary more than 3000.
12) Display the names of the employees who are working in the company for the past 5 years.
13) Display the list of employees who have joined the company before 30-JUN-90 or after 31-DEC-90.
14) Display current Date.
15) Display the list of all users in your database (use catalog table).
