I have doubt about the following functions in sql server
Rank(),
Row_Number(),
NTILE()
Partition By
And Over with example..?
Without know doubt, no one can help you. post your doubt here
while,
Rank function returns the rank of each row within the partition of a result set. The rank of a row is one plus the number of ranks that come before the row.
Row Number function returns the sequential number of a row within a partition of a result set, starting at 1 for the first row in each partition.
NTile function returns the group number & distributes the rows in an ordered partition into a specified number of groups. The groups are numbered, starting at one. For each row, NTILE returns the number of the group to which the row belongs.
binson143
Member
424 Points
179 Posts
Explain the new ranking functions in SQL SERVER
May 09, 2012 11:46 AM|LINK
I have doubt about the following functions in sql server
Rank(),
Row_Number(),
NTILE()
Partition By
And Over with example..?
nijhawan.sau...
All-Star
16410 Points
3173 Posts
Re: Explain the new ranking functions in SQL SERVER
May 09, 2012 11:54 AM|LINK
Did you see th explanation and examples on msdn
http://msdn.microsoft.com/en-us/library/ms176102.aspx
yrb.yogi
Star
14460 Points
2402 Posts
Re: Explain the new ranking functions in SQL SERVER
May 09, 2012 12:11 PM|LINK
Without know doubt, no one can help you. post your doubt here
while,
.Net All About
bhaskar.mule
Contributor
2270 Points
659 Posts
Re: Explain the new ranking functions in SQL SERVER
May 09, 2012 12:17 PM|LINK
hi
refer this
http://csharpektroncmssql.blogspot.com/2012/01/ranking-functions-in-sqlserver.html
thanks
Site:Rare technical solutions