I need all questions fast darabase sql oracle 1. 2. 3. 4. 5. 6. 7. 8. 9.

I need all questions fast darabase sql oracle

Transcribed Image Text:

1. 2. 3. 4. 5. 6. 7. 8. 9. Write an SQL query to fetch the list of employees with different salaries. Write an SQL query to show the second highest salary from a table. table. Write two SQL queries that remove all data inside a Use two ways to get all information about the employee with the lowest salary in employee table. Create a table that copy all employees table attributes but only copy department 80 employees. Define a sequence that starts from 20210001 and insert one row with this sequence. Write an SQL query to Show average salaries with two decimal point for each department in employee's table. Write and sql query to modify all null values in commission pct column and make it 0.01. Write an SQL query to show the name of department that has the maximum salary among all departments and also show that salary. 10. Write and SQL query to show all employees information that has higher salary than all employees in department 80. 11. 12. Write an SQL query to show the employees with lowest 10 salaries of employee's table Create a view that shows the name and the salary for the employees at IT department only. 13. 14. 15. Use right Padding function to add a hash (# ) to all employees if their names have less than 20 characters. Write and SQL query to show all employees information that has higher salary than any employee in department 80. Merge the employee_ID and name columns from employee table and make them look like this [first last : id] and call it "Employee Info". 1. 2. 3. 4. 5. 6. 7. 8. 9. Write an SQL query to fetch the list of employees with different salaries. Write an SQL query to show the second highest salary from a table. table. Write two SQL queries that remove all data inside a Use two ways to get all information about the employee with the lowest salary in employee table. Create a table that copy all employees table attributes but only copy department 80 employees. Define a sequence that starts from 20210001 and insert one row with this sequence. Write an SQL query to Show average salaries with two decimal point for each department in employee's table. Write and sql query to modify all null values in commission pct column and make it 0.01. Write an SQL query to show the name of department that has the maximum salary among all departments and also show that salary. 10. Write and SQL query to show all employees information that has higher salary than all employees in department 80. 11. 12. Write an SQL query to show the employees with lowest 10 salaries of employee's table Create a view that shows the name and the salary for the employees at IT department only. 13. 14. 15. Use right Padding function to add a hash (# ) to all employees if their names have less than 20 characters. Write and SQL query to show all employees information that has higher salary than any employee in department 80. Merge the employee_ID and name columns from employee table and make them look like this [first last : id] and call it "Employee Info".