No video :(

Oracle interview question, Difference between Rank and Dense Rank

Подписаться 47 тыс.

Просмотров 103 тыс.

50% 1

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
easy-learning-...

Опубликовано:

21 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 55

@martinsuresh5048 6 лет назад

very helpful information hatsoff sir

@vivektarab16 Месяц назад

Start 0:14 - Rank and Denserank 2:28 - Now we will see how to write a Query

@Cheema1111 3 года назад

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

@SivaAcademy 3 года назад

Yes you are correct 👍

@rahulpanari9923 4 года назад

Awesome explanation. Thank you sir

@SivaAcademy 4 года назад

You are welcome

@publicpoint1032 4 года назад

Good explanation sir These are the best vedios in this year

@SivaAcademy 4 года назад

Thanks for your comments bro 🙏🙏🙏

@juno7893 4 года назад

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

@SivaAcademy 4 года назад

Welcome....Thank you so much :-)

@vishalbhardwaj969 3 года назад

What is industry use cases of rank and dense rank

@juno7893 3 года назад

@@vishalbhardwaj969 Capital Markets

@rahulpanari9923 4 года назад

Great explanation..keep it up sir

@SivaAcademy 4 года назад

Thanks and welcome

@caseyjody9898 7 месяцев назад

Thanks well explained

@SivaAcademy 7 месяцев назад

Thank you

@kubalajohn7390 2 года назад

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?

@harishabm8138 4 года назад

Good explanation sir Thanks

@SivaAcademy 4 года назад

Welcome Harisha

@jayeshjagtap6565 3 года назад

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

@mokshadakothari1265 3 года назад

good video

@SivaAcademy 3 года назад

Thank you

@kalpeshpatil4321 4 года назад

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.

@SivaAcademy 4 года назад

sure, please stay tuned

@sammedchougule7489 11 месяцев назад

diffrance between union ,union all, minus ,intersect

@ravising4145 4 года назад

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

@SivaAcademy 4 года назад

many places, whereever we need to rank bank on values, for ex, rank for mark, or amount spend in a month based on category etc,,

@tusharsonwane8468 Год назад

Thank you sir❤️

@SivaAcademy Год назад

Welcome bro

@narendra_ingle 3 года назад

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

@DharmrajSahu 3 года назад

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.

@SivaAcademy 3 года назад

If you are already working, then I won't suggest for classes, because its easy for working professional to read through and prepare, the interview question series will cover 70 percent of learning, and you need to concentrate on practical scenario. Many questions already posted, however this needs practice