IS NULL

Monday, December 21, 2009

Find the Nth maximum salary in sql

Find N th maximum salary using rank() function

select * from(
select dense_rank() over(order by salary desc) as rank,name from employee ) as empsalary
where rank=2
Posted by Guna at 10:51 PM
Labels: SQL

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Labels

  • C# (2)
  • Silverlight (1)
  • SQL (2)
  • Sql Server Interview Questions (16)
  • SSAS - SQL Server Analysis Services Interview Questions (15)
  • SSIS (1)
  • SSRS - SQL Server Reporting Services Interview Questions (3)
  • WCF (5)
  • Windows Forms (3)

Blog Archive

  • ►  2016 (1)
    • ►  September (1)
  • ►  2015 (1)
    • ►  November (1)
  • ►  2014 (30)
    • ►  November (1)
    • ►  September (1)
    • ►  August (2)
    • ►  July (26)
  • ►  2012 (2)
    • ►  May (1)
    • ►  April (1)
  • ►  2010 (5)
    • ►  February (4)
    • ►  January (1)
  • ▼  2009 (7)
    • ▼  December (2)
      • Find the Nth maximum salary in sql
      • WCF Binding
    • ►  November (4)
    • ►  October (1)
Awesome Inc. theme. Powered by Blogger.