CTE | Common Table Expression (part-1) | Non-Recursive CTE | SQL Server Advanced (বাংলা) - #07
Welcome to Advanced SQL Bangla (বাংলা) tutorial.
CTE | Common Table Expression (part-1) | Non-Recursive CTE
This video explains how CTE or Common Table Expression works and uses cases of CTEs with real life example.
Topics:
CTE / Common table expression
Syntax of CTE
Example of CTE
Comparison between CTE and Subquery
Comparison between CTE and Temp Table
✅ SQL Script used in this video: https://drive.google.com/file/d/1qVaQ...
✅ Table Create and Data Insert script: https://drive.google.com/file/d/1Zhsq...
Previous Videos:
🎬 SQL Temp Table: • SQL Temp Table | Temporary Table | SQL Ser...
🎬 Group By Clause: • Group By Clause | SQL Server For Beginners...
✴️ SQL Server For Beginners Full Playlist:
• SQL Server For Beginners
Timestamp
00:00 Intro
00:25 Scenario describe
03:44 What is CTE
06:00 Syntax of CTE
07:36 Example of CTE
11:16 Why CTE performs better than Subquery
12:38 CTE vs Temp Table
#sqlserver #devalap #sqlbangla #database