Your company’s employee information is stored in a SQL Server database. You want to identify the names of employees whose salaries are with a 10-percent range of the average salary in your company. Which of the following queries will return this information?

Your company’s employee information is stored in a SQL Server database. You want to identify the names of employees whose salaries are with a 10-percent range of the average salary in your company. Which of the following queries will return this information?

Your company’s employee information is stored in a SQL Server database. You want to identify the names of employees whose salaries are with a 10-percent range of the average salary in your company. Which of the following queries will return this information?


Answer: – DECLARE @s money
SELECT @s = AVG(Salary) FROM Employees
SELECT LName, FName, Salary From Employees
WHERE ABS)Salary - @s)/@s < 0.1

(Only c generates a plus and minus result; that is, you want to be within 10 percent, or plus or minus 10 percent.)