SQL query for finding the first, second and third highest numbers

Question

What is an example query to retrieve the first, second and third largest number from a database table using SQL Server?

Answer 1

You can sort by your value descendingly and take the top 3.

SELECT TOP 3 YourVal FROM YourTable ORDER BY YourVal DESC