Thursday 25 January 2018

select 2 highest salary

SELECT Top 1 totalamount from
 ( select top 2 totalamount from [order] order by totalamount desc
 ) T
  order by TotalAmount



No comments:

Post a Comment