.Net

By Piush Shukla

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
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: Nth Highest Salary Record In Sql Server

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (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

  • ►  2025 (2)
    • ►  July (1)
    • ►  April (1)
  • ►  2022 (5)
    • ►  June (1)
    • ►  April (3)
    • ►  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)
      • Nth Highest Salary Record In Sql Server
      • Client Side Validation in asp.net, Required Field,...
      • How to select Only One CheckBox In Grid View
    • ►  November (3)
Ethereal theme. Powered by Blogger.