What is the Ranking functions?

What is the Ranking functions?

Ranking Function is the bassically use for the return value which is the ranking of the each row in the partion. These ranking functins are non Deterministic. there are many diff type of ranking functions :
> ROW_NUMBER() OVER([])
> RANK() OVER([])
> DENSE_RANK() OVER([])

By:UMANG
Date:2013-01-09 00:00:00

Post Your Answers


User Email:

User Name:
Answers:

Related SQL Subjective Links

SQL Subjective interview questions and answers for experienced and fresher