找出由大到小第N個項目，蠻有創意的SQL寫法

http://duckfly-tw.blogspot.tw/2017/03/n.html

找出由大到小第N個項目

找出由大到小第N個項目，蠻有創意的SQL寫法

1 2 3 4 5 6 7

SELECT * FROM Employee Emp1 WHERE (N-1) = ( SELECT COUNT(DISTINCT(Emp2.Salary)) FROM Employee Emp2 WHERE Emp2.Salary > Emp1.Salary )