SQL Server - Ranking Functions, CTE Vs Derived Tables Vs Temp Tables

[@vkatta2105]

Wonder-full Explanation , i have gone through other videos but was really not able to understand which one to you use when and the main advantages of using one over the other. Keep up the Good work and thanks for sharing your Knowledge Cheers!!!

[@sowmyatangirala8438]

Excellent explanation.Worth the watch!!

[@yonashabtesllassie5642]

The way you present is very simple and clear, I have used a lot. Thank you Mr. Bhaskar

[@BhaskarJogiSQLandBI]

You are most welcome

[@subramanianxganesan]

Such a great video and explanation I have ever seen in TH-cam. Thank you so much.

[@BhaskarJogiSQLandBI]

Glad it was helpful!

[@datatech9922]

Awesome Boss! Fantastic explanation

[@nareshmaddiveni7814]

awesome explanation without dought.

[@janardhanreddy3267]

Such a wonderful explantation Sir

[@BhaskarJogiSQLandBI]

Keep watching

[@mandiralamichhanedahal5401]

well explained sir.....the way you explained is very very very clear .... you are awesome. thank you so much for your time .. loved it ❤❤❤❤❤❤❤❤❤❤❤❤❤❤

[@BhaskarJogiSQLandBI]

Thanks a lot

[@ewnetm6420]

It’s very helrpfull. Thank u!!!!

[@MrArde09]

Wonderful explanation thanks sir for wonderful video

[@ragavanethirajan9213]

very simple and clear explanation sir thank u :)

[@rohanverma3777]

Wow sir u r good u provide deep knowledge sir 🙏

[@mounikakode7172]

super sir, your explanation is very clear.

[@bipanpreetkaur2184]

Awesome 👍

[@altafraza372]

You can use max() in select Query.

[@aknawnega4186]

Thank you very much,

[@BhaskarJogiSQLandBI]

You are welcome!

[@leelachitla6220]

Super Boss...

[@suneelyadav7553]

SUPER AWESOME

[@BhaskarJogiSQLandBI]

Thanks!!

[@nareshbuddy9522]

Where can I download this Data Base That We are Using Here

[@venkatasubbareddyonteru4581]

sir ,it's giving error when i use like select *,row_number() over (order by sal) from emp; ..after * row_number not accepting

[@vidigyamishra6523]

35:13 FOR CTE- give the database link

[@janardhanreddy3267]

Please share the tables sir

[@vidigyamishra6523]

give database link here

[@SivaKumar-kl1dh]

Please send me ibank database link

[@janardhanreddy3267]

please share tables sir to practice, i sent a mail to you sir