1.

nth highest number from table

Answer»

Hi PUT NUMBER in the place of nth

SELECT TOP 1 number
FROM (SELECT DISTINCT TOP 'nth' number
FROM EMPLOYEE ORDER BY number DESC) a
ORDER BY number ASC


Discussion

No Comment Found

Related InterviewSolutions