third or nth maximum salary from salary table


declare @NthRow int
declare @RN int

WITH CTE AS
(
    SELECT EmpID, EmpName, EmpSalary,
           RN = ROW_NUMBER() OVER (ORDER BY EmpSalary DESC)
    FROM dbo.Salary
)
SELECT EmpID, EmpName, EmpSalary
FROM CTE
WHERE RN = @NthRow



select top  1 sid from
(select top 5 sid from TblStudents order by sid ) a
order by sid desc

select top  1 sid from TblStudents a
where 5-1=(select distinct count(sid) from TblStudents b where a.sid>b.SID  ) 

select * from 
( select *,ROW_NUMBER() over (order by sid ) rn from TblStudents  ) a
where rn=5


select * from 
( select *,RANK() over (partition by name order by sid ) rn from TblStudents  ) a
where rn=1


select * from TblStudents order by sid desc

Comments

Post a Comment

Popular posts from this blog

loop example

-------------- using foreach loop using System;                               public class Program {       public static void Main()       {                         char charCout = 'o';          int Count = 0;             string  strFirst =  "Hello World";              foreach(char chr in strFirst) {              if (chr == charCout) {                  Count++;...
Read more

View vs Partial View MVC

The primary difference is that a Partial View is designed to be rendered within other full Views and as a result it will not contain all of the markup that a full View might ( since it is designed to work within other Views ). For example, a normal View might look like this and contain all of the elements present in a traditional HTML page :  <!DOCTYPE html> <html> <head> <meta charset = utf-8 /> <title> Example </title> </head> <body> <!-- Your Content Here --> </body> </html> where as a Partial View might only contain a small section that it needs to render and since it should be displayed within an existing View, it won't require the necessary tags like <head>, <html>, etc. because it is implied that these should already be present when a Partial View is rendered. An example partial View might look like this :  <div> <!-- Example --> <ul> ...
Read more