SQL_QA

Oracle SQL Interview Questions and Answers

1. Write a SQL Query to delete a duplicate records?

2. Write a SQL Query for first 4 characters of first_name column from emp table?

3. We have two tables called emp and emp_address and the comon column is emp_no and write the query to get the data from both tables and create a table with that data?

4. Write a query to get all even number emp_no employees from emp table?

5. Write a query to get employees whose salary is less than to his manager salary and greater than to other managers?

6. Write a query to get the last five salaries by department wise?

7. Write a query to get the 3rd higest salaried emp in each department?