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?
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
More Microsoft SQL Server MCQ Questions