Rank and Dense Rank in MySQL - Important SQL Interview Question

No video

Rank and Dense Rank in MySQL - Important SQL Interview Question

Рет қаралды 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

Пікірлер: 132

@sumitmittal07 Жыл бұрын

Checkout the Big Data course details here: trendytech.in/?referrer=youtube_sql16

@msns15 Жыл бұрын

I have been learning SQL from quite a long time and have been working on and off using SQL, but this is the first time ever I have felt this confident in answering certain SQL questions and solving certain advanced queries. Must say this is one of the best but underrated SQL playlist. Thank you so much for this playlist, also if you can please make some videos on lead() and lag() and the group by extensions, that would be super helpful.

@tushartiwari7929 2 жыл бұрын

If professor have taught in this fashion, it could have saved a few years. Thank you Sumit Sir ❤️

@manishgurunule2189 2 жыл бұрын

I was Scared of ROW_NUMBER (), RANK() and DENSE_RANK(). After watching this video I can't never forget these functions. Thank you sir

@sumitmittal07 2 жыл бұрын

Good to hear that you could understand the concepts easily.

@kavyasri6654 Жыл бұрын

Yes sir me too, Thank you so much 😊

@Princyy Жыл бұрын

This is my first course or series I can say which I've completed in my life because everytime I start something and end up feeling bored but this was amazing series having pool of knowledge into it. Thank you to Sumit sir and his team for bringing this much amazing series on KZfaq for free. Also I would recommend everyone to go for this series and believe me this guy has god gifted teaching skills which will fall in love with SQL.

@swadhinsonwane4185 Жыл бұрын

I can completely relate to this even i also watched the entire playlist 😅

@Amit-jp7vt Жыл бұрын

I was always confused with joins , group by and having clauses in my college days but your explainations has removed my confusions now i am feeling confident in mastering sql. Thankyou Sumit Sir👌. Please contd with this series, its a masterpiece on youtube please cover some more topics like stored procedures & functions.

@vikashbist6820 4 ай бұрын

There are very less playlist that I complete from start to end and I must say this is one of those, Loved the content level and the way you describe examples and that to from basic I started this playlist for my revision perspective but got to know new methods and ways to write those query and the specially the Rank and Row_number methods are bit confusing but you did a great job, Who so ever is starting this playlist just go for it, If a begineer within a week you can complete this and if for revision in 3 days... but also do handson, again Thank you Sumit sir for this valulable playlist.

@omairkhan7672 2 жыл бұрын

Someone please give award for the "BEST PROFESSOR" to this man. THANK YOU SUMIT SIR!

@ichapurammohini8842 2 күн бұрын

sir u explain very nicely. I always use to get confuse among these window functions concepts. Thankyou sir for clearing all doubts

@rokibhasan5184 6 ай бұрын

I've completed the whole playlist. Before this one I checked out many courses on SQL but they do not teach like you did. This is amazing. The best part is you've covered how questions can come in interviews.

@sumitmittal07 6 ай бұрын

thank you very much got such motivating words

@vaishaknambiar3365 Жыл бұрын

Sumit Sir, you are a saviour! I haven't seen anyone teaching SQL concepts so clearly with apt examples. Thankyou so much!

@venkataram6460 2 жыл бұрын

Hi Sir, why did you stop uploading the SQL videos. These are quit useful and interesting. Please continue this SQL playlist. Thankyou very much for your content

@sumitmittal07 2 жыл бұрын

Will upload soon

@venkataram6460 2 жыл бұрын

@@sumitmittal07 thank you very much

@himanshujain4749 Жыл бұрын

@@sumitmittal07 sir still waiting for further concepts

@AyushIND24 Жыл бұрын

@@sumitmittal07?? Fastt

@zaffer2024 3 ай бұрын

finished watching all 16/16 in a single go. practice is next.

@parinayrikhy9021 11 ай бұрын

Thanks for all the SQL videos, your examples are very good. I've recommended your videos to 7 of my friends already. I finally cleared my confusion over Row_Number and the Rank functions. .

@YogeshSharma-cs2pq Жыл бұрын

his is my first course or series I can say which I've completed in my life because everytime I start something and end up feeling bored but this was amazing series having pool of knowledge into it. Thank you to Sumit sir and his team for bringing this much amazing series on KZfaq for free.

@i_amsubho Жыл бұрын

Is this SQL series enough to learn full concept of SQL?

@arpithaks3467 29 күн бұрын

Best teacher got in my entire life

@sumitmittal07 19 күн бұрын

Means a lot. Thank you so much

@thesvaan 8 ай бұрын

Nice lessons. Well put for beginners and nice refresher for the experienced. Suggestions: Please revisit select distinct with order by video. That definitely needs to be redone as it is not clearly explained. Also, in this video instead of 3 sql queries showing 3 different outputs, it could be clubbed as different columns for even easier understanding. Thank you!

@yashviragnihotri9561 2 жыл бұрын

cant be thankful enough for this series

@umarfarooque3687 Жыл бұрын

I finished this series .... very good way of teaching

@itsme1674 Жыл бұрын

Thank you Sumit Sir for this wonderful playlist. You have amazing teaching style. I revised all concepts in 5hr in one sitting. It's amazing 😍

@gauravgupta5530 2 жыл бұрын

24-Aug-2022 ended this playlist and waiting for more videos @Trendytech Insights. Very helpful videos.

@YoSpidy1 4 ай бұрын

Not the hero we expected but the one we needed

@CelebrateWithVani Жыл бұрын

Thank you sir for making this video! I was not understanding the concept of row_number() but you made so clear that even I got to know about ranks and dense ranks. Have a great day sir! :)

@dudetastic4521 2 жыл бұрын

Thank you so much Sumit, for this sql series...It was super useful for me to understand the concepts clearly. Please don't stop this and upload much more concept videos frequently.💫

@rupaliminati8356 Жыл бұрын

Hey is this a full course of SQL please reply

@dudetastic4521 Жыл бұрын

@@rupaliminati8356 Not really.... but it covers all the important concepts which we must know in data field

@rupaliminati8356 Жыл бұрын

@@dudetastic4521 hey can yoilu suggest any youtube course to learn SQL for placments , thank you

@dudetastic4521 Жыл бұрын

@@rupaliminati8356 This SQL playlist is enough for interviews and for practicing problem solving.

@dkkashyap6494 Жыл бұрын

Undoubtedly the bestest SQL tutorial ... even better than every paid courses... I'm thankful to you from the bottom of my heart core...

@LEVI-hv8dw Жыл бұрын

Is the SQL sessions over.......was this the final chapter in SQL?

@dkkashyap6494 Жыл бұрын

@@LEVI-hv8dw it has covered almost 90% of the sql topics, you can clear maang level interviews with this

@LEVI-hv8dw Жыл бұрын

@@dkkashyap6494 and what about cte ?

@dkkashyap6494 Жыл бұрын

@@LEVI-hv8dw depends on where you apply.. And after learning this skill you need to show your skill using some projects on this topic.. Project is a must

@LEVI-hv8dw Жыл бұрын

@@dkkashyap6494 what kind of project i need to work on and how to improve my query writing skills......any tips for that?

@neerajthakur6200 2 жыл бұрын

Great learning through your SQL playlist. Approach is Very simple and with lots of practical examples but I made a mistake I thought I would get a link of your whole SQL playlist notes in the last video description and I continued watching it without making any notes and now when I completed it. I got to know that there is no such link its my bad. It its possible for you would you please share your notes link here. THANKS IN ADVANCE.

@muhammadhuzaifa6705 Жыл бұрын

did u get?

@nagarajuk1250 2 жыл бұрын

Thank you very much for giving good knowledge in SQL.

@harshrajvaghela699 2 жыл бұрын

sir ap sad mat ho ke baar pure playlist banake to deko app bhohat acah padhate ho ap bohat age javo ge par app kam suru karke katam to karo sir i depanded on you ples requst for starting atutorial \

@atulnagar1841 Жыл бұрын

Hello Sumit Sir! I want to be a master in SQL if you have any paid courses for it please suggest me because these 16 lectures are the best lectures on youtube and also the best explanation of SQL. Thankyou sir.

@ishukumar2041 Жыл бұрын

Hi Atul i also want to learn the advance topic by paid course , do you want to share paid course ? half half

@atulnagar1841 Жыл бұрын

@@ishukumar2041 definitely if I find any course I will suggest you.

@ishukumar2041 Жыл бұрын

@@atulnagar1841 Thanks Atul

@SanthoshKumar-fw4dz Жыл бұрын

@@atulnagar1841 Brother you can learn advance topics in techTFQ channel. He teaches well.

@atulnagar1841 Жыл бұрын

@@SanthoshKumar-fw4dz thanks bro

@sachinsalamwadkar6286 Жыл бұрын

Sir Your all SQL session help me lot. Can I get notes which used for explaining SQL.

@radhikakadam4343 Жыл бұрын

too much hardwork really thank you so much sir.

@email5940 2 жыл бұрын

Pls put more videos of SQL if anything left or it's enough for big data course?

@yashdhas8202 2 жыл бұрын

Thank you so much Sir. Awesome Session.

@sumitmittal07 2 жыл бұрын

Always welcome. Keep watching the space for more :)

@deepakg7428 4 ай бұрын

Ever best trained by any other thanks

@KhushisDreaM 2 жыл бұрын

SQL is my favorite lang 💯✨

@shubhampokhriyal8491 2 жыл бұрын

Great video how many videos remaining in this series?

@aryanvik5614 2 жыл бұрын

Yep How many more videos remaining sir ??

@heenagirdher6443 2 жыл бұрын

Thank you so much, Sir. Best Explanation.

@mallikarjunpatil7553 2 жыл бұрын

Great videos, liked the way it was explained 👍 It's almost 2 weeks, no new topic Waiting for more videos

@sumitmittal07 2 жыл бұрын

Thank you so much 😀 Keep watching

@Nikhil-qi4oz 4 ай бұрын

Please continue this SQL Series sir

@NAVEENKUMAR-nd7jg Жыл бұрын

Thanks sir very good explanation

@sjain5 2 жыл бұрын

Thank you so much sir for great video ! ✅

@sumitmittal07 2 жыл бұрын

Keep watching. I am happy that you are liking the videos.

@bhrigumonibaruah251 2 жыл бұрын

Is it over or more videos to come?

@vikneshwararb3354 Жыл бұрын

Hello Sumit sir.Please post videos about Normalization forms.

@oneminuteshorts8868 2 жыл бұрын

great explaination sir thanks

@parth_chovatiya 2 жыл бұрын

kindly, provide that pdf / txt file, where you have written all things

@ganeshsahu280 Жыл бұрын

very good explanation

@boginenivenugopal6214 2 жыл бұрын

Could you please share the notes so that it will be useful for us

@akashjayaweera8856 2 жыл бұрын

Great Explanation. 🎊

@KhushisDreaM 2 жыл бұрын

Thnkuu so much sir for this sql series ✨✨✨

@bharathreddy_4 2 жыл бұрын

Sir, please do snowflake course videos..

@subratabhanu2627 Жыл бұрын

Sir please continue this series with complete sql.

@parulkhattar28 5 ай бұрын

are these topics required to be studied- stored procedures, views, triggers, index, CTEs, ?

@sumitmittal07 5 ай бұрын

Triggers, Views, Window Functions, CTEs, Indexes are important.

@Factskingdom6088 Жыл бұрын

Hello sir , thank you for this wonderful session . Is this sql playlist the complete course ???

@rajnandinipadhy2533 2 жыл бұрын

the dense rank does the job of finding nth sal or any other similar query so what is the need of rank then??

@adameve1784 2 жыл бұрын

Please continue SQL playlist

@lavanyalavi6678 2 жыл бұрын

Hloo Sumit sir, please do one video on how to convert rows to columns

@vishnujatav6329 2 жыл бұрын

Thank you very much

@giridhararaomaddirala2472 2 жыл бұрын

Hi Sumit sir, please make a video on lead() and lag()

@balramlowanshi3819 Жыл бұрын

Did you have any plsql sessions video based on your scenario .

@saurabhdhyani4498 2 жыл бұрын

Great video SIr!

@gouthamireddy1278 2 жыл бұрын

hi sir, pls continue this sql topics

@harshrajvaghela699 2 жыл бұрын

sir when come next tutorial

@nixacademy3395 2 жыл бұрын

Sir is this playlist complete or not? Are you planing to complete this playlist or not?

@kiranshah177 2 жыл бұрын

There is nothing new in it. Why so much of hype... This topic is already explained beautifully three years ago by kudvenkat. You can check the sql by kudvenkat He is the champ in SQL.

@dudechany 2 жыл бұрын

Well to answer your question ..this video is a part of SQL tutorial series and the word "tutorial" is meant to indicate that it is for people who don't know about what is being discussed in videos , I hope this answers your "nothing new part" as it was "new" for me before I watched this video. Now to answer your "why so much hype" part ..I would like to ask you who is creating a hype here ? do you see the creator of this video claiming this to be the best tutorial on KZfaq ? Most of the people who come here to see Sumit's videos is because we like the way he teaches and also because of his reputation from other courses that he offers. Venkat may be a champ but I simply don't relate with the way he teaches.

@kiranshah177 Жыл бұрын

@@dudechany only chamcha can reply in this way 😌

@dudechany Жыл бұрын

@@kiranshah177 Great reply !! I am sorry I assumed that you may be a well educated professional but the choice of your language has made it very clear to me that there is no sense in indulging with you in a discussion.

@anandbabuselvam2662 2 жыл бұрын

row number is not working in goorm ide

@dammitanothername 2 жыл бұрын

recommendations: who cares about loading the data, the data doesn't matter, don't show it; use a proper IDE; no scrolling. You should be able to fit everything in one screen. You can comment out your notes in mysql workbench, show the complete query, and show the results below the query all in one screen. Otherwise great and thanks.

@sumitmittal07 2 жыл бұрын

These videos are also meant for the larger audience who are just getting started with SQL. Thanks for the feedback!

@ThomasShelby-xr1sk 2 жыл бұрын

can't we use only partition by inside over() ?

@sunilrao6090 6 ай бұрын

after this video, SQL is completed? Please someone answer my question, sumith sir

@vittal255 2 жыл бұрын

Sir I am interested in learning the course however I have a concern, I am in manufacturing company I can't leave my present job. Will this skill will help me in extra earning

@santoshsable1 2 жыл бұрын

Yes, this skill will help you to fetch various reports from the database where all your manufacturing data is stored.

@TomJerry-bp9ig Жыл бұрын

Please upload more videos sir. I beg you😭 I belong from very poor family and can't afford paid courses😭

@altamashansari7047 2 жыл бұрын

Yeh series mein total kitna video or upload hona bakee hain??

@email5940 2 жыл бұрын

Have you uploaded session 16 or 15 sessions are enough?? Pls reply

@sumitmittal07 2 жыл бұрын

I have almost covered all the topics needed. If need be it, I might add few more videos covering the advanced concepts.

@email5940 2 жыл бұрын

@@sumitmittal07 Is it enough for your big data course? I mean your 15 sessions or do I need to learn more??

@sanchitsharma2899 2 жыл бұрын

Is the course completed with this Video @sumit sir

@rudraraju2467 2 жыл бұрын

Pleas upload more videos

@gauravsinghtanwar4415 2 жыл бұрын

When are the new videos coming on SQL ??

@aheribanerji7056 Жыл бұрын

Pls pls pls share the notes.

@kapilkale2453 2 жыл бұрын

Sir where is the notes of the above videos?

@bkcy18 2 жыл бұрын

Is there a github repo where i can find these sessions?

@sumitmittal07 2 жыл бұрын

Not as of now.

@bkcy18 2 жыл бұрын

@@sumitmittal07 please try and add one if possible. Will be helpful for quick lookups.

@vinodkumarbodiga6741 2 жыл бұрын

Waiting for next video sir ???

@sumitmittal07 2 жыл бұрын

Coming up soon

@harshrajvaghela699 2 жыл бұрын

sir intaha ho gaye intaza ke

@harshrajvaghela699 2 жыл бұрын

sir intaha ho gaye intaza ke

@careershala3598 2 жыл бұрын

sir new video kab ayegi

@sumitmittal07 2 жыл бұрын

coming tuesday se...

@gauravgarg6614 2 жыл бұрын

@@sumitmittal07 sir please upload new videos

@aheribanerji7056 Жыл бұрын

@@sumitmittal07 pls share the notes.

@learner-xu5tw Жыл бұрын

CREATE TABLE employee ( firstname varchar(20), lastname varchar(20), age int, salary int, location varchar(20) ); INSERT INTO employee VALUES ('sachin', 'sharma', 28, 10000, 'bangalore'); INSERT INTO employee VALUES ('shane', 'warne', 30, 20000, 'bangalore'); INSERT INTO employee VALUES ('rohit', 'sharma', 32, 30000, 'hyderabad'); INSERT INTO employee VALUES ('shikhar', 'dhawan', 32, 25000, 'hyderabad'); INSERT INTO employee VALUES ('rahul', 'dravid', 31, 20000, 'bangalore'); INSERT INTO employee VALUES ('saurabh', 'ganguly', 32, 15000, 'pune'); INSERT INTO employee VALUES ('kapil', 'dev',34, 10000, 'pune');

@gawandevaibhav2376 Жыл бұрын

Hi Sir, why did you stop uploading the SQL videos. These are quit useful and interesting. Please continue this SQL playlist. Thankyou very much for your content