SELECT TOP 1 SALARY FROM (SELECT DISTINCT TOP N SALARY
FROM EMPLOYEE ORDER BY SALARY DESC)SAL
ORDER BY SALARY
FROM EMPLOYEE ORDER BY SALARY DESC)SAL
ORDER BY SALARY
Place the value in place of N.
---Technical Concepts,Scenarios,Architectures,Tips and Tricks On .Net and SQL Server Technologies
No comments:
Post a Comment