Oracle interview question, Difference between Rank and Dense Rank

Oracle interview question Difference between Rank and Dense Rank

Both RANK() and DENSK_RANK() function gives the ranking within the ordered partition of data, However if same rank is assigned to more than one record, then the next rank(s) will be skipped by RANK() function, whereas, the ranks are consecutive for DENSE_RANK. No ranks will be skipped in case of DENSE_RANK even if more than one row are assigned with same rank.

List of all the SQL and PLSQL interview questions

[juno]

Wow! I didn’t know anything about those functions. Very good explanation. Thank you.

[publicpoint]

Good explanation sir
These are the best vedios in this year

[Cheema]

Hello sir, as u said on 1:58 that last rank is equal to the total number of employees and that is the keycheck that whether rank has been calculated rite or not...but if the last two 2 salaries would have been '1248' only, the last 2 ranks would be 13-13 only. so in a way we cannot calculate number of rows with rank.
correct me if i am wrong

[jayeshjagtap]

Thank you so much ....!! Can we have video on difference between 10g, 11g and 12c

[kubalajohn]

Sir, good explanation but where do you need to use Rank and where do you use Dense Rank? How do a developer know which one to use? If the rank is same which record is picked first in the order by series? can it be randomly picked?

[ravising]

Thanks shiva but can u tell me where we can used rank function

[bharathipandian]

Siva, pls explain about oracle architecture. It's been asked in am interview

[narendra_ingle]

Must be share advantages or real time example or use of rank function

[DharmrajSahu]

Sir i have just started learning PL/SQL myself and also given some interviews but i need to learn more. So can you please guide me how to learn. If you suggest to join your classes, I will.

[rampradeepkalivarapu]

Can you plz explain difference between last_value and last functions in OLAP

[kalpeshpatil]

Can you please make a video on regular expression and type of regular expression with small example in easy way to get it understand.
It will be very thankful, if you make video on this.
Thanks in advance cheers.

[ashutosh]

Please give an example of Rank, Dense_Rank and all other Analytical functions using Partition.

[venkateshprasad]

Hi Siva,
Hope your doing well.
In what scenario we need to use rank and dense rank

[sammedchougule]

diffrance between union, union all, minus, intersect

[vivektarab]

Start

0:14 - Rank and Denserank

2:28 - Now we will see how to write a Query

[subhalakshmi]

Please let me know it r y talking any class shiva