MCQs > IT & Programming > Microsoft SQL Server > 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?

Microsoft SQL Server MCQs



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?

Answer

Correct Answer: SELECT TOP 2 * FROM engineers ORDER BY salary DESC

Explanation:

Note: This Question is unanswered, help us to find answer for this one

Microsoft SQL Server Skill Assessment

Overall Skill Level-Poor

Your Skill Level: Poor

Retake Quizzes to improve it

search

Microsoft SQL Server Skill Assessment

Overall Skill Level-Poor

Your Skill Level: Poor

Retake Quizzes to improve it