Finding Nth Highest Salary Query

By -
SELECT max(sal) FROM  tbltemp WHERE sal NOT IN
(SELECT distinct top 2 sal FROM tbltemp ORDER BY sal desc)

for eg. for 3rd highest top will be 3-1 =2  (top 2) therefore top N-1


Or



SELECT TOP 1 sal 

FROM (

               SELECT DISTINCT TOP 2 sal
               FROM tbltemp
              ORDER BY sal DESC
              ) A
ORDER BY sal

Comments

Post a Comment

Popular posts from this blog

How to get motherboard serial number, Processor ID, VolumeSerialNumber using C#?

By -
Add using System.Management; namespace in your application then //Get motherboard's serial number ManagementObjectSearcher mbs = new ManagementObjectSearcher("Select * From Win32_BaseBoard"); foreach (ManagementObject mo in mbs.Get()) { textBox1.Text = mo["SerialNumber"].ToString(); } //Get Processor's Identity mbs = new ManagementObjectSearcher("Select * From Win32_processor"); foreach (ManagementObject mo in mbs.Get()) { textBox2.Text = mo["ProcessorID"].ToString(); } //Get Network Adapter Configuration mbs = new ManagementObjectSearcher("Select * From Win32_NetworkAdapterConfiguration"); foreach (ManagementObject mo in mbs.Get()) { textBox3.Text = mo["MACAddress"].ToString(); break; }
Read more

Fiserv Interview Questions.

By -
1) For edit functionality in DataGird specify Column name 2) Why you may not want to use Paging funtionality in data grid 3) Function of SqlCommanBuilder in code. 4) Find the error in code . Its related to database connection. I think that connection sould be closed in finally instead of try. 5) What is the relation between src='' & Inherits='' in <@ Page > directive 6) What is derective in the user control page & its extention of file 7) Question related to 404 error code Error page & Default error page. 8) Its related to Autherization in web config related to folders 9) Related to definition 10) not remembred with question but answer is cookiless = true related question 11) Page is posting the 2 times why is it so 1) user control load 2) some control call load 12) describe !Page.PostBack Select Options 13) Question related to Session mode = SQLServer 14) Some question related to validation control - compare validator 15) Some question
Read more

AngularJs - Simple Example

By -
In Angular "-" is used because HTML specification says that anything with - will not be parsed by HTML. Means If you will use - in element naming then other needs to parse it. So in thins case Angular will parse elements. $scope - Is a Angular Service for a scope management. As per the following code, Each ng-controller scope is different. $scope is parameter for your function and angular will inject $scope object into your function. $rootScope - Application have only one rootScope and which is global. This code will create object of customer class  and this controller will have his scope under that scope he do have access to Customer Name and Customer Code.  <div  ng-controller ="customerObj">  $scope.$watch ("CustomerAmount", function() - This is the customer watch code ng-App - In one HTML file you can have only one ng-app. ::  is considered a one-time expression. One-time expressions will stop recalculating once they are stable,
Read more