you have a table engineers with the following structure enggid int 4..., MS SQL Server 2005, Databases

MS SQL Server 2005

Test
- Model Test
Index

Question:You have a table "engineers" with the following table structure:
enggid                int(4)
name                varchar(50)
salary                int(4)

You want to select the top 2 engineers in the decreasing order of their salaries, starting with the maximum salary. Which of the following SQL queries will fetch this data?

A SELECT TOP 2 * FROM engineers ORDER BY max(salary) DESC 
B SELECT TOP 2 * FROM engineers ORDER BY salary DESC, GROUP BY salary 
C SELECT TOP 2 * FROM engineers GROUP BY salary DESC 
D SELECT TOP 2 * FROM engineers ORDER BY salary DESC 
E SELECT TOP 2 [name], salary FROM engineers ORDER BY salary DESC

/76

+ AnswerD E

+ Report

Descriptive on MS SQL Server 2005 Ebook

Total Preview: 1082

Question:You have a table "engineers" with the following table structure: enggid int(4) name varchar(50) salary int(4) You want to select the top 2 engineers in the decreasing order of their salaries, starting with the maximum salary. Which of the following SQL queries will fetch this data?

A SELECT TOP 2 * FROM engineers ORDER BY max(salary) DESC

B SELECT TOP 2 * FROM engineers ORDER BY salary DESC, GROUP BY salary

C SELECT TOP 2 * FROM engineers GROUP BY salary DESC

D SELECT TOP 2 * FROM engineers ORDER BY salary DESC

E SELECT TOP 2 [name], salary FROM engineers ORDER BY salary DESC

D E