SQL CTE in Hindi | CTE in SQL | What is CTE in Sql

SQL CTE | CTE in SQL | What is CTE in Sql | SQL Common Type Expression
CTE is like divide and conquer approach. You can use CTE for complex queries. Divide the complex queries in small query and make the readability better.
SQL CTE in Hindi help you to learn what are sql CTE, what are types of CTE.
This video also demonstrate how to create CTE with example and diagram.
MS SQL Hindi Playlist : • SQL Tutorials-Hindi
MS SQL English Playlist : • SQL Tutorial-English
Power BI DAX Hindi Playlist : • DAX Hindi
Power BI DAX English Playlist : • DAX English
Power BI Hindi Playlist : • Power BI Tutorials-Hindi
Power BI English Playlist : • Power BI Tutorials-Eng...
#sqlserver #sql #sqlinterviewquestions #mssqlserver #sqlforbeginners #education #rdbms #sqlcourse #sqlcommands

[@user-to6ou8tw4w]

VERY AWSOME AFTER LONG TIME I UNDERSTAND CTE 🤩

[@lotusamaze1142]

Thanks

[@khatariinsaan5284]

Thank you so much sir, your Explanation is always superb

[@lotusamaze1142]

Thanks

[@nd8223]

Beginner friendly still very effective

[@lotusamaze1142]

Glad you think so!

[@crismil1983173]

धन्यवाद आपका

[@lotusamaze1142]

glad, it helped you.

[@topcode_111]

awesome!!!

[@lotusamaze1142]

Thank you! Cheers!

[@SanjayKumar-yh8fd]

Thanks sir

[@lotusamaze1142]

Welcome

[@entertaintvshorts]

Superb

[@lotusamaze1142]

Thanks 🤗

[@hindi-english1664]

thank you for clarifying my doubt in CTE, you giving precious knowledge to subscribers always.

[@lotusamaze1142]

Any time

[@DeepakSahu-fi2bu]

Hello sir, God bless your efforts. I am a newbie sql learner with a simple enquiry. Why i cannot set constraints or indexes for CTE's? Thanks .

[@lotusamaze1142]

CTE just creates the temporary result set in memory so constrains and index can not be applied

[@KiranSingh-bk8uz]

Hello Sir, Please make a Sql video, Why we use cross apply and Outer Apply with of subquery

[@lotusamaze1142]

sure and very soon

[@vikasrajput226]

@@lotusamaze1142 Sir , have you made cross apply video ? If yes kindly share link here.

[@Aarabin_Nayak]

Sir, I have one doubt: should we run both the SQL query as per your first three-column result set and the query in an inner join? Are these both different types or a single query ?

[@lotusamaze1142]

It is a single query

[@akashrajput801]

sir kya apke sql notes ki pdf mil sakti hai 😑😑😑😑😑

[@akshay29yt50]

Sir student table ko ctTotal ke sath join Karne se pahle ,cte ki all query kaise run ki

[@akshay29yt50]

Plz reply sir samaz nhi araha

[@lotusamaze1142]

it is default behavior of sql runs whole code as a unit

[@smartyarshad303]

Is it working in phpmyadmin

[@lotusamaze1142]

Sorry, I dont have idea of MySql

[@smartyarshad303]

@@lotusamaze1142 ok no issue

[@rishikesh831]

too much confusion in recursive CTE

[@lotusamaze1142]

Practice makes perfect