RANK - Returns the rank of each row within the partition of a result set.
Syntax - RANK ( ) OVER ( [ partition_by_clause ] order_by_clause )
Example - RANK() OVER (order by Mark) AS Rank
(OR) RANK() OVER (partition by subject order by Mark) AS Rank
NTILE
DENSE_RANK
ROW_NUMBER
PERCENT_RANK
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.