Find 1, 2,3 and nth highest salary
select top 1 salary from (
select distinct top n salary from tab order by salary desc ) a
order by salary asc
Subscribe to:
Post Comments (Atom)
About Me
+of+IMG_1821.jpg)
- Mukesh
- Having 6 years of experience in design, development and implementation of MSBI,Web and window Based Product, Solutions and commercial applications and got a good experience in developing SOA based solutions integrating web services (SOA) from diverse platforms, my expertise also includes BI(business intelligence) solutions. My domain areas include health care, Finance, BI, SAAS and client-server three tier applications.
No comments:
Post a Comment