SQL Server Query MCQs

Question 21: Select the query to increase and update the Salary of all employees by 20% in the Employee table.

Question 22: Write a query to copy all data from table1 to table2.

Question 23: Write a query to fetch records having the lowest 3 salaries from the Employee table.

Question 24: Identify the valid SQL statement to display the number of employees in each department whose average salary is greater than 25000.