How to get n th highest value in Sql Server table?

SELECT TOP 1 fieldname FROM (SELECT TOP 9 fieldname FROM tablename ORDER BY fieldname desc) AS E ORDER BY fieldname asc

No comments:

Post a Comment

Plz Share your comments...