SQL Server interview question :- Explain RowNumber,Partition,Rank and DenseRank ?

Watching in 2025!

Thanks Sir

good content

Helped me in 2023 December! Thank you so much for this amazing teacher. 🙏

thankyou, really helpful

how dense rank is different from partitioned , i mean if you apply partition on customer name it work as same as dense rank

Very clear and easy to understand, Thanks

Made in 2012 helping forever 💖
Watching this video for my upcoming interview 😊🐕😙

Second highest amount based on vendor name?

Row number is used to give sequential integral number to every row (starting with 1)

2023, but still the best video to understand these topics. Thanks a lot Sir.

Хорошо объяснил. Спасибо из России.

Very well explained 🔥

Thank you!

We r unable to see the after execution of query because of ur content display on video

Great videooo this used to confuse me alot but now easy pezyyy!!!

Not all heroes wear capes, and you are one of them! thank you so much

superb sir. I have one doubt how to partition the row_number by alphabetical order sir

How beautifully and with an ease he has taught.... Thankyou sir🙏🏻

Very nice explanation, thank you for this video

what happens if you just select row_number()? Without the over window functions?

Really cool👍

Great explained sir,i was looking this only

very good

You are a God for explaining this. Thank you, liked and subscribed!

atisundar

I love how Archies was big thing in 2012 and now it's just something we use to know! 😅🤷🏻‍♀️ In contrast to this video though.. it's still imp 🥺. Thanks for the video !

Can you use row number + partition to get the same result as rank and dense rank.

Can you use row number + partition to get the same result as rank and dense rank.

Really njoyed and easily understand the concept tq sir

Thanks, Good Video. If we want to explain in one liners - Row_numbers generate IDs; Rank Generates Rank and skips subsequent ranks if the same rank is assigned for multiple rows; a dense_rank make sure ranks are not skipped. is that right?

A gentleman who is both technical and philosophical. Thank you sir.

Thankyou 😊🙏

Very neatly explained! Thank you so much! :D

To this content maker, thank you a lot for explaining this in the most simplest way. I had a real hard time to understand the simple concept of Row_number. Thanks again.

2022 also

I see your after 9 year and Today date is 4.3.2022

Thankyou

CREATE TABLE Persons (
PersonID int,
);
Insert into persons values(1);
Insert into persons values(2);
Insert into persons values(3);
Insert into persons values(4);
Insert into persons values(5);
Insert into persons values(4);
select * from Persons;
CREATE TABLE Perso (
PersonID int,
);
Insert into Perso values(1);
Insert into Perso values(2);
Insert into Perso values(3);
Insert into Perso values(7);
Insert into Perso values(5);
Insert into Perso values(3);

SELECT * from Persons INNER JOIN Perso on Persons.PersonID = Perso.PersonID;
SELECT * from Persons LEFT JOIN Perso on Persons.PersonID = Perso.PersonID;
SELECT * from Persons RIGHT JOIN Perso on Persons.PersonID = Perso.PersonID;
SELECT * from Persons FULL JOIN Perso on Persons.PersonID = Perso.PersonID;
can u tell is this correct values are fine only need to join these two tables

Very helpful video. Explained the concepts in 10 mins

Simplest but most effective.. one of the best videos for learning

Best and Simplest video ever on rank, partition, row_number and something new i learnt the dense_rank. Keep up the great work ! you are awesome

2022

Very useful 👍

hi sir you are explained very well compare with others lectures

thank you sir

@Query(value="SELECT * FROM(SELECT RANK() OVER PARTITION BY c.CX_CA_ID ORDER BY c.CX_EVENT_DATE DESC) AS R,c.* FROM cxt_event_data c) WHERE CX_EVENT_STATUS='PENDING' ORDER BY CX_EVENT_DATE DESC",nativeQuery=true)
This is my query this is running fine in sql developer but getting exception sql command not properly ended in eclipse

Onew word thank you❤️

Well explained. Thank you :)