SubsDotNet

Wednesday, 15 January 2014

Find Only 3rd Maximum Salary from Employee Table using Sql Server?

Ans:-

select top 1 sal from employee where sal in(select top 3 sal from employee order by sal desc) order by sal
Posted by Subs Dot Net Full Stack Technology at 08:56
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

  • ►  2023 (23)
    • ►  November (20)
    • ►  October (3)
  • ►  2018 (31)
    • ►  March (6)
    • ►  February (25)
  • ▼  2014 (80)
    • ►  July (2)
    • ►  June (6)
    • ►  April (12)
    • ►  March (45)
    • ►  February (4)
    • ▼  January (11)
      • CheckBoxList Operations in Asp.Net
      • Drop Down List with Text Box Operation in Asp.Net
      • Generate Crystal Report using Web Service in ASP.NET
      • Handle Exception in Stored Procedure using RAISERR...
      • Add Column,Constraint(Primary Key,Foreign Key) to ...
      • W.A.Q with Example of Query,Joins,Functions and St...
      • Gridview CRUD Operations using VB.NET
      • Registration Form Validation using Java Script Reg...
      • Gridview CRUD Operations using 3-Tier Architechtur...
      • Find Only 3rd Maximum Salary from Employee Table u...
      • Find Top 3 maximum Salary from Employee Table in S...
  • ►  2013 (29)
    • ►  December (9)
    • ►  November (18)
    • ►  October (2)

About Me

Subs Dot Net Full Stack Technology
View my complete profile
Picture Window theme. Powered by Blogger.