Correlated Subquery in SQL | Subquery in SQL | SQL in tamil | Tech with Hema Tamil

Correlated Subquery in SQL | Subquery in SQL | SQL in tamil | Tech with Hema Tamil #sql #sqlintamil
Learn subquery in tamil. You will see more videos in sql basics that will be coming soon. Please add your comments in the comment box if you like me to cover any other topics in sql that you are interested. Thank you.
Queries used in the video can be accessed through this link - drive.google.c...
Subquery video - • Subquery in SQL | SQL ...
Installation of Microsoft SQL server and SQL server management studio - • Installation of Micros...

[@ashwinwilfred1344]

nice explanation.... thanks

[@saranyars611]

Hi Mam, I have one doubt in correlated subquery we use update, insert, delete statement or not

[@SakthiVel-fz3xi]

correlate subquery detail la explain pannunga mam

[@Joe-cw1fg]

How to improve query writing using correlated sub query like this

[@kodivicky7970]

Cte_query explanation

[@mullaipugazhendi3236]

Hi could you please post a video on level concept

[@TechWithHema]

Thanks for your comment @mullaipugazhendi3236. Level concept is in Oracle and it is not available in MSSQL. Probably, you can try using recursive CTE and change it according to your use case. WITH Generate_list AS (
SELECT 1 as list
UNION ALL
SELECT list+1
FROM Generate_list
WHERE list < 100
)
SELECT * FROM Generate_list