StatCounter

View My Stats

Tuesday, February 5, 2008

To found n'th Salary Of a Recods:SQl Server

The query as Follows:

select top 1 salary from (select distinct top 2 salary from table1 order by salary desc) a order by salary

Here
salary-Column Name
table1-Table Name
a-Concatenation..It may be any other character
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

  • Name value collection in C#
    Name value collection in C# The name value collection is same like the HashTable. We can set the Object value and the Key to that par...
  • What are Structural Design Patterns?
    What are Structural Design Patterns? A structural design pattern establishes a relationship between entities. Thus making it easier for...
  • Creating a Cookie in ASP.NET
    Creating a Cookie  in ASP.NET #region Creating Cookies HttpCookie JayaCookie = Request.Cookies["CookieExample"]; ...