.Net

By Piush Shukla

Showing posts with label Nth Highest Salary Record In Sql Server. Show all posts
Showing posts with label Nth Highest Salary Record In Sql Server. Show all posts

Monday, 26 December 2011

Nth Highest Salary Record In Sql Server


SELECT TOP 1 [Salary]
FROM 
(
SELECT  DISTINCT TOP 2 [Salary]
FROM [dbo].[Employee]
ORDER BY [Salary] DESC
) temp
ORDER BY [Salary] 
Posted by Piush shukla at 04:11 No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: Nth Highest Salary Record In Sql Server
Older Posts Home
Subscribe to: Posts (Atom)

Piush Shukla has about 5 years of work experience on Microsoft technologies (C#.NET,Asp.Net,WPF,

Piush shukla
View my complete profile

Blog Archive

  • ▼  2022 (4)
    • ▼  April (3)
      • test
      • ^(?:\d{10}|(\()?\d{3}(?(1)\))(?:([- ])| )\d{3}(?:\...
      • ^[a-zA-Z -&]+$allow character, space, ampersand a...
    • ►  March (1)
  • ►  2017 (1)
    • ►  September (1)
  • ►  2016 (14)
    • ►  May (1)
    • ►  April (13)
  • ►  2015 (18)
    • ►  December (18)
  • ►  2014 (11)
    • ►  July (3)
    • ►  April (2)
    • ►  January (6)
  • ►  2013 (24)
    • ►  December (11)
    • ►  November (7)
    • ►  July (6)
  • ►  2012 (324)
    • ►  December (1)
    • ►  November (2)
    • ►  September (1)
    • ►  August (3)
    • ►  July (1)
    • ►  June (2)
    • ►  May (5)
    • ►  April (67)
    • ►  March (35)
    • ►  February (77)
    • ►  January (130)
  • ►  2011 (6)
    • ►  December (3)
    • ►  November (3)
Ethereal theme. Powered by Blogger.