Rank and Dense Rank in MySQL - Important SQL Interview Question

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!

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

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

very good explanation

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');

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.

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

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

Sir please continue this series with complete sql.

Hello Sumit sir.Please post videos about Normalization forms.

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

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! :)

Thanks sir very good explanation

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

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

too much hardwork really thank you so much sir.

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

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

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 😍

Pls pls pls share the notes.

Thank you very much for giving good knowledge in SQL.

Thank you so much, Sir. Best Explanation.

Pleas upload more videos

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

row number is not working in goorm ide

Sir where is the notes of the above videos?

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

Is the course completed with this Video @sumit sir

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

Great Explanation. 🎊

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

great explaination sir thanks

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

hi sir,
pls continue this sql topics

Great video SIr!

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

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

sir new video kab ayegi

Please continue SQL playlist

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

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.

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

\

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

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

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