ะ ะตั าะฐัะฐะปะดั 46,830
๐๐๐ง๐ญ ๐ญ๐จ ๐๐๐ฌ๐ญ๐๐ซ ๐๐๐? ๐๐๐๐ซ๐ง ๐๐๐ ๐ญ๐ก๐ ๐ซ๐ข๐ ๐ก๐ญ ๐ฐ๐๐ฒ ๐ญ๐ก๐ซ๐จ๐ฎ๐ ๐ก ๐ญ๐ก๐ ๐ฆ๐จ๐ฌ๐ญ ๐ฌ๐จ๐ฎ๐ ๐ก๐ญ ๐๐๐ญ๐๐ซ ๐๐จ๐ฎ๐ซ๐ฌ๐ - ๐๐๐ ๐๐ก๐๐ฆ๐ฉ๐ข๐จ๐ง๐ฌ ๐๐ซ๐จ๐ ๐ซ๐๐ฆ ๐๐ฒ ๐๐ฎ๐ฆ๐ข๐ญ ๐๐ข๐ซ!
"๐ 8 ๐ฐ๐๐๐ค ๐๐ซ๐จ๐ ๐ซ๐๐ฆ ๐๐๐ฌ๐ข๐ ๐ง๐๐ ๐ญ๐จ ๐ก๐๐ฅ๐ฉ ๐ฒ๐จ๐ฎ ๐๐ซ๐๐๐ค ๐ญ๐ก๐ ๐ข๐ง๐ญ๐๐ซ๐ฏ๐ข๐๐ฐ๐ฌ ๐จ๐ ๐ญ๐จ๐ฉ ๐ฉ๐ซ๐จ๐๐ฎ๐๐ญ ๐๐๐ฌ๐๐ ๐๐จ๐ฆ๐ฉ๐๐ง๐ข๐๐ฌ ๐๐ฒ ๐๐๐ฏ๐๐ฅ๐จ๐ฉ๐ข๐ง๐ ๐ ๐ญ๐ก๐จ๐ฎ๐ ๐ก๐ญ ๐ฉ๐ซ๐จ๐๐๐ฌ๐ฌ ๐๐ง๐ ๐๐ง ๐๐ฉ๐ฉ๐ซ๐จ๐๐๐ก ๐ญ๐จ ๐ฌ๐จ๐ฅ๐ฏ๐ ๐๐ง ๐ฎ๐ง๐ฌ๐๐๐ง ๐๐ซ๐จ๐๐ฅ๐๐ฆ."
๐๐๐ซ๐ ๐ข๐ฌ ๐ก๐จ๐ฐ ๐ฒ๐จ๐ฎ ๐๐๐ง ๐ซ๐๐ ๐ข๐ฌ๐ญ๐๐ซ ๐๐จ๐ซ ๐ญ๐ก๐ ๐๐ซ๐จ๐ ๐ซ๐๐ฆ -
๐๐๐ ๐ข๐ฌ๐ญ๐ซ๐๐ญ๐ข๐จ๐ง ๐๐ข๐ง๐ค (๐๐จ๐ฎ๐ซ๐ฌ๐ ๐๐๐๐๐ฌ๐ฌ ๐๐ซ๐จ๐ฆ ๐๐ง๐๐ข๐) : rzp.io/l/SQLINR
๐๐๐ ๐ข๐ฌ๐ญ๐ซ๐๐ญ๐ข๐จ๐ง ๐๐ข๐ง๐ค (๐๐จ๐ฎ๐ซ๐ฌ๐ ๐๐๐๐๐ฌ๐ฌ ๐๐ซ๐จ๐ฆ ๐จ๐ฎ๐ญ๐ฌ๐ข๐๐ ๐๐ง๐๐ข๐) : rzp.io/l/SQLUSD
๐๐๐ง๐ญ ๐ญ๐จ ๐ฅ๐๐๐ซ๐ง ๐๐ข๐ ๐๐๐ญ๐ ๐๐ฒ ๐๐ฎ๐ฆ๐ข๐ญ ๐๐ข๐ซ?
๐๐ก๐๐๐ค๐จ๐ฎ๐ญ ๐ญ๐ก๐ ๐๐ข๐ ๐๐๐ญ๐ ๐๐จ๐ฎ๐ซ๐ฌ๐ ๐๐๐ญ๐๐ข๐ฅ๐ฌ
๐๐๐๐ฌ๐ข๐ญ๐ : trendytech.in/...
I have trained over 20,000+ professionals in the field of Data Engineering in the last 5 years.
Rank and Dense Rank in MySQL - Important SQL Interview Question
In this video we will talk about how to use Rank function & Dense Rank function in SQL and its industry use case.
Remember -
We should be using the order by clause
We can also use the partition by - but its optional
the row number starts from 1 for every partition
Do Like, Comment & Subscribe :)
๐๐ผ๐ถ๐ป ๐บ๐ฒ ๐ผ๐ป ๐ฆ๐ผ๐ฐ๐ถ๐ฎ๐น ๐ ๐ฒ๐ฑ๐ถ๐ฎ:๐ฅ
๐
Sumit LinkedIn - / bigdatabysumit
๐
Sumit Instagram - / bigdatabysumit
Notes -
if there are no duplicates then row number, rank and dense rank lead to similar results..
only the difference comes when there are duplicates..
rank - for duplicates same rank is assigned and the for the next entry it skips the ranks..
dense rank - it does not skip any ranks in between
whenever you do not have duplicates use row_num
This is a very frequently asked SQL Interview question.
#SQL #RDBMS #database #bigdata #dataengineering