Msbi Knowledge sharing blog

I would like to share my knowledge and open to recieve knowledge from others.

Thursday, 27 December 2012

How to find second highest salary using cte?


second highest salary
with cte as
(
select salary,ROW_NUMBER() over (order by salary desc) as 'rownum'
from dbo.employee
)
select salary from cte where rownum=2
Posted by Unknown at 23:11
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

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

Blog Archive

  • ►  2013 (14)
    • ►  July (3)
    • ►  June (1)
    • ►  May (1)
    • ►  March (2)
    • ►  February (2)
    • ►  January (5)
  • ▼  2012 (58)
    • ▼  December (20)
      • Difference between Delete and Truncate
      • Try catch block in sql
      • Temptables,Tablevariables,Ctes comparison?
      • How to find second highest salary using cte?
      • SQLSERVER BEGINNER SAMPLE DATABASE
      • Differences between stored procedures and functions?
      • Merge statement?
      • difference between not in and not exists in sql s...
      • How to replace the null values in sql server?
      • How to raise an error in Trigger?
      • Magic Tables in sql server?
      • union and union all differences?
      • Triggers_Basics in sql sever
      • SQL QUERIES
      • How to remove duplicate records in a table in sql ...
      • Isolation levels in sql server?
      • How to use self join in sql server?
      • set ansi nulls on and quoted identifier on/off in ...
      • order of clauses in sql server?
      • where vs having clause in sql server?
    • ►  November (18)
    • ►  October (20)

About Me

Unknown
View my complete profile
Ethereal theme. Powered by Blogger.