Oracle SQL Queries: Basic Exercises with Solution

Oracle Queries: Basic [15 exercises with solution]

1. Write a Oracle SQL query to get the details of all employees and also display the specific information of all employees.

Click me to see the solution

2. Write a Oracle SQL command to display the employee name, job and annual salary for all employees

Click me to see the solution

3. Write a Oracle SQL query to get the total number of employees working in the company.

Click me to see the solution

4. Write a Oracle SQL query to get the total salary being paid to all employees.

Click me to see the solution

5. Write a Oracle SQL query to get the maximum and minimum salary from the employees table.

Click me to see the solution

6. Write a Oracle SQL query to display the name of the employees in order to earning from lowest salary to highest.

Click me to see the solution

7. Write a Oracle SQL query to display the name of the employees in order to earning from highest salary to lowest.

Click me to see the solution

8. Write a Oracle SQL query to display the name of the employees in order to alphabetically ascending order.

Click me to see the solution

9. Write a Oracle SQL query to display employee id, name, department no, salary of the employees. The output first based on the employee name in ascending order, for unique name department will come in ascending order, and for same name and department the highest salary will come first.

Click me to see the solution

10. Write a Oracle SQL query to display the name and their annual salary. The result should contain those employees first who earning the highest salary.

Click me to see the solution

11. Write a Oracle SQL query to display department id and total number of employees working in each department.

Click me to see the solution

12. Write a Oracle SQL query to display the designation (job id) and total number of employees working in each designation.

Click me to see the solution

13. Write a Oracle SQL query to display the department number and total salary for each department.

Click me to see the solution

14. Write a Oracle SQL query to display the department number and maximum salary for each department.

Click me to see the solution

15. Write a Oracle SQL query to display the designations (job id) and total salary allotted for each designation from the company.

Click me to see the solution

More to Come !