SQL interview question

1. How to find nth highest salary in SQL Server using a Sub-Query
2. How to find nth highest salary in SQL Server using a CTE
3. How to find the 2nd, 3rd or 15th highest salary

















To find 2nd highest salary we can use any of the above queries. Simple replace N with 2. 

Similarly, to find 3rd highest salary, simple replace N with 3. 







Comments

Post a Comment

Popular posts from this blog

Prime Number Program in C#

Prime number is a number that is greater than 1 and divided by 1 or itself. In other words, prime numbers can't be divided by other numbers than itself or 1. For example 2, 3, 5, 7, 11, 13, 17, 19, 23.... are the prime numbers. using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; namespace ConsoleApplication1 {     class Program     {         static void Main(string[] args)         {             int number, i, m = 0, flag = 0;             Console.WriteLine("PLEASE ENTER THE NUMBER TO CHECK PRIME NUMBER");             number = int.Parse(Console.ReadLine());             m = number / 2;             for(i=2;i<=m;i++)             {           ...
Read more

Fibonacci Series in C#

In the case of Fibonacci series, the next number is the sum of the previous two numbers for example 0, 1, 1, 2, 3, 5, 8, 13, 21 etc. The first two numbers of Fibonacci series are 0 and 1. using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; namespace ConsoleApplication1 {     class Program     {         static void Main(string[] args)         {             int val1 = 0, val2 = 1, val3, i, number;             Console.WriteLine("Please Enter any number");             number = int.Parse(Console.ReadLine());             Console.WriteLine(val1 + " " + val2);             for (i=2;i<=number;i++)             {                 val3 =...
Read more

Joins in SQL server

Image
In SQL server, there are different types of JOINS. 1. CROSS JOIN 2. INNER JOIN  3. OUTER JOIN  Outer Joins are again divided into 3 types 1. Left Join or Left Outer Join 2. Right Join or Right Outer Join 3. Full Join or Full Outer Join Now let's understand all the JOIN types, with examples and the differences between them.   Employee Table (tblEmployee)   Departments Table (tblDepartment) SQL Script to create tblEmployee and tblDepartment tables Create   table  tblDepartment (      ID  int   primary   key ,      DepartmentName  nvarchar ( 50 ),      Location  nvarchar ( 50 ),      DepartmentHead  nvarchar ( 50 ) ) Go Insert   into  tblDepartment  values  ( 1 ,   'IT' ,   'London' ,   'Rick' ) Insert   into  tblDepartment  values  ( 2 ,   'Payroll' ,   'Delhi' , ...
Read more