Handling the BOTTOM Function in Sql Server

Name Wage
Michel $870
jacob $1000

So as we know there is only a TOP command , and no similar BOTTOM command, if you want to get the employees with the highest wages instead of the top two employees from the Employee table, the top two employees (the highest wages) would have to be selected from the table ordered in descending order. As in above example we have selected top 2 record based on the highest wage value with condition desc order. Means get the result from bottom of the result set.

Add Comment