Skip to main content

Can you get second highest salary from the table?

Query:-

SELECT Emp_Name,Emp_Salary
FROM Employee e1
WHERE
2 = (SELECT COUNT(DISTINCT (e2.Emp_Salary))FROM Employee e2 WHERE e2.Emp_Salary >= e1.Emp_Salary)

The above employee table contains two same records as second highest salary so the result set will look like below output table.

Output:-

Emp_Name Emp_Salary
Sham 15000
Labels:

Comments

Post a Comment

Popular posts from this blog

Drawing Line Charts In asp.net

LineChart.cs import the following namespaces using System.Drawing; using System.Drawing.Drawing2D; using System.Drawing.Imaging; using System.Collections; public class LineChart { public Bitmap Bitmapb; public string strTitle = "Default Title"; public ArrayList ArrayListchartValues = new ArrayList(); public float ftXorigin = 0, ftYorigin = 0; public float ftScaleX, ftScaleY; public float ftXdivs = 2, ftYdivs = 2; private int intWidth, intHeight; private Graphics Graphicsg; private Page Pagep; struct datapoint { public float ftx; public float fty; public bool bolvalid; } //initialize public LineChart(int intmyWidth, int intmyHeight, Page myPage) { intWidth = intmyWidth; intHeight = intmyHeight; ftScaleX = intmyWidth; ftScaleY = intmyHeight; Bitmapb = new Bitmap(intmyWidth, intmyHeight); Graphicsg = Graphics.FromImage(Bitmapb); Pagep = myPage; } pu...
Post a Comment
Read more

AJAX

ASP.NET AJAX From Wikipedia, the free encyclopedia Jump to: navigation, search ASP.NET AJAX is a set of extensions to ASP.NET developed by Microsoft for implementing Ajax functionality. It is released under the Microsoft Public License. Contents [hide] • 1 Road Map • 2 Browser support • 3 ASP.NET AJAX Suite • 4 Microsoft Ajax Library • 5 The UpdatePanel Control • 6 Script Controls and Extenders • 7 Web-services and JSON • 8 See also • 9 References • 10 External links [edit] Road Map In its early development stages, ASP.NET AJAX was given the code name Atlas. Initial releases were made public to the development community in the form of CTPs (Community Technical Previews). The production version, ASP.NET AJAX 1.0 RTM; was released on January 23, 2007[1][2] as an extension to ASP.NET 2.0. Important release milestones for ASP.NET AJAX are as follows: • CTPs - October, December 2005, January, March, April, June, July 2006 • Beta - October, November 2006 • Release Candidate (RC) - December 2...
Post a Comment
Read more