RANK, DENSE_RANK, ROW_NUMBER SQL Analytical Functions Simplified

Thankyou sir

Great explanation sir....tq

Thanks for this!

Very nicely explained!

Very good explanation and easier to understand. Earlier I'm unable to understand difference between these 3 functions now I'm clear. Thank you so much for this video.

Very nicely explained and in easy to understand. Great job!

Great video Ankit. Very nicely executed with all three functions running simultanesouly and that brings the difference so accurately. Great job.

Thankyou .After lots of watching videos finally my concept is cleared here.

Enhancing clarity leads to an interest in learning. Thank you Ankit.. !

Very good explanation, short and concise

Thanks alot sir✨

Bro ye where clause vala kesey kiya ....mujmey to error show kr raha hai ki 'rnk unknown column in where clause

I feel it should be in english so it would be helpful.

Very nice explanation

Sir, instead of using 'PARTITION BY' clause inside the rank statement, can't we use 'GROUP BY' department_id in the end of the query, in order to get the ranks as per salaries of the departments ?

Thank you Ankit this was very easy to understand. Can you post some more interview questions using RANK(), DENSE RANK() and ROW_number

thnks

Language is not understanding sometimes, if you tell in English it will be helpful

Thanks for the video!

Not understanding the language

Hi Ankit, If possible can you please explain your videos in English please.

Clear and Crisp

Thank You Sir, Clear understood✌👌

Thank you so much for your hard work. It's really very useful to understand the Analytical Functions.

Clear explanation 💯 For those asking for dataset:
create table employee(
emp_id int,
emp_name varchar(20),
dept_id int,
salary int
);
insert into employee values(1,'Ankit',100,10000);
insert into employee values(2,'Mohit',100,15000);
insert into employee values(3,'Vikas',100,10000);
insert into employee values(4,'Rohit',100,5000);
insert into employee values(5,'Mudit',200,12000);
insert into employee values(6,'Agam',200,12000);
insert into employee values(7,'Sanjay',200,9000);
insert into employee values(8,'Ashish',200,5000);

Really very good explanation sir! Thank you very much:)

great explanation and the best thing here is using small dataset to simplify concepts in a short span

please help me why alias was added at the last to get output i want to visualize how it works.

Thanks Ankit

Nice explanation

Understood teh concept in a very simple way. Thank you :)

I am planning to complete all the SQL videos created by you in order to learn SQL. I will post a comment on each video and like it as a checklist for completed videos, starting from the beginning.

All are amazing videos.Very clear experience. It is very useful to refresh the SQL before interview.I am working as AVP in citicorp.Thank you very much Recently I used ur amazing videos to clear interview. Thank you very much.

Really helpful

1/122

Great Learning with you Ankit😊

I didn't understand analytical function until I see this video.
Thank you for explain in simple word to understand. 👍

Appreciated bro 👍

This Explanation Blew my mind..!!
From Scaring.. To Caring..on SQL. its just because of u Guruji🙏🙏

Nice explanation.. I have a doubt performance wise rank or dense rank is better

It's very helpful Sir thank you please make more this types of vedio 😊

thanks sir its good to understand easily in hindi as compare to english

Thanku ♥️

Same question asked in my yesterday interview 👍👍

hatoff to big brother love from noida ................you cleared concept like piece of cake

Thank you Ankit ! it was a very simple and clear explanation.

That's the simplest and most understandable explanation :) Thank You !!

Good morning Sir where we can practice online SQL ?

JUST WOW