NTILE function in sql server

Saranya Boopathi
Posted by Saranya Boopathi under Sql Server category on | Points: 40 | Views : 1328
Ntile:NTILE function in sql server divides the result set into a specified number of groups based on the ordering and optional partition.

Select *,NTILE(7) over(order by BookId) as Quartile 
from Book_Details

Comments or Responses

Login to post response