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

[@yonashabtesllassie5642]

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

[@BhaskarJogiSQLandBI]

You are most welcome

[@sowmyatangirala8438]

Excellent explanation.Worth the watch!!

[@subramanianxganesan]

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

[@BhaskarJogiSQLandBI]

Glad it was helpful!

[@datatech9922]

Awesome Boss! Fantastic explanation

[@janardhanreddy3267]

Such a wonderful explantation Sir

[@BhaskarJogiSQLandBI]

Keep watching

[@nareshmaddiveni7814]

awesome explanation without dought.

[@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

[@rohanverma3777]

Wow sir u r good u provide deep knowledge sir 🙏

[@ewnetm6420]

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

[@MrArde09]

Wonderful explanation thanks sir for wonderful video

[@mounikakode7172]

super sir, your explanation is very clear.

[@ragavanethirajan9213]

very simple and clear explanation sir thank u :)

[@bipanpreetkaur2184]

Awesome 👍

[@leelachitla6220]

Super Boss...

[@altafraza372]

You can use max() in select Query.

[@suneelyadav7553]

SUPER AWESOME

[@BhaskarJogiSQLandBI]

Thanks!!

[@aknawnega4186]

Thank you very much,

[@BhaskarJogiSQLandBI]

You are welcome!

[@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

[@vidigyamishra6523]

give database link here

[@janardhanreddy3267]

Please share the tables sir

[@SivaKumar-kl1dh]

Please send me ibank database link

[@janardhanreddy3267]

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