Row_number(), Rank(), Dense_rank(), Ntile(int)

Row_number(), Rank(), Dense_rank(), Ntile(int):

CREATE TABLE [dbo].[emp321]
(
 [id] [int]  NULL,
 [name] [varchar](20) NULL,
 [city] [varchar] (20)NULL,
 [dept] [varchar](10) NULL,
 [salary] [money] NULL
)
insert into emp321 values(100,'Kishore','bangalore','IT',32000)
insert into emp321 values(101,'pavan','bangalore','HR',32000)
insert into emp321 values(102,'mahesh','pune','Slaes',24000)
insert into emp321 values(103,'harish','mumbai','IT',42000)
insert into emp321 values(104,'ramya','pune','HR',26000)
insert into emp321 values(105,'swetha','bangalore','Slaes', 26000)
insert into emp321 values(106,'sindhu','pune','IT', 34000)
insert into emp321 values(107,'naresh','mumbai','HR',30000)
insert into emp321 values(108,'kumar','mumbai','Slaes', 30000)
insert into emp321 values(109,'ashok','bangalore','IT', 42000)
insert into emp321 values(110,'siva','madanapalli','IT',36000)

select * from emp321

Query:

Select Salary,ROW_NUMBER() over(order by salary)[row number],RANK() over(order by salary)[rank],

DENSE_RANK() over (order by salary)[dense rank],ntile(5) over(order by salary) [ntile] from emp321 

Result:

Observer the result set .............