CTE in SQL | CTE in Tamil | With clause in SQL | SQL in tamil | Tech with Hema Tamil

[@samphoenix1623]

Always explain with an example, all will remember and use it correctly. 🎉thanks

[@kedarnathk6326]

Clear way of teaching in a simple way.really appreciatable.well understood the CTE clause

[@TechWithHema]

Thanks @kedarnathk6326

[@samphoenix1623]

Thank you and effective way of teaching a SQL concept which will be remembered easy and for longer time thank you once again ❤🎉

[@ShittheswaranSelvakumar]

Romba nalla explanation.. romba nanri Hema avargale..

[@TechWithHema]

Nanri @ShittheswaranSelvakumar

[@karthickg4746]

Excellent explain ❤

[@josejoel9346]

Mam neenga solli kodukura concept ellame super, neenga use panra data konjam discription la podunga naanga andha datavai vaithu easy ah practice pana mudium mam..

[@TechWithHema]

Thanks @josejoel9346. Queries are there in the description already. Data used in CTE video is from AdventureWorks database. I have added the link to import that database in the description now.

[@priyadarshini3284]

Mam, if I download that. It tells data is large and I'm not able to get properly. Can any one help. Which flies i want to open inmobile

[@nandinipundipandu6163]

@@priyadarshini3284 it doesn't open in mobile coz it contains massive data.It's better to work in your laptop or computer

[@thenuchellappen4688]

Very well explained thanks a lot sis

[@periasamy5563]

Very nice explanation of cte.

[@TechWithHema]

Thanks @periasamy5563

[@ismailcbewin]

1.difference between cte and temp table, which one is better performance?
2. Difference Between CTE and Temp table and Table variables?
3.How cte will use in temp table?
Please explain those areas.

[@krishnarajr5731]

nice explanation. but once request from me kindly share the raw data for practice purpose. It would be more useful for learning. if it's possible means kindly share the raw data.

[@logamuthu7562]

I got the job because of your videos 🙏🏽

[@TechWithHema]

Glad to know that my videos helped you🙏 Congrats logamuthu

[@aravindhanc5087]

Hi mam, your definition for SQL concepts are crisp and clear . can you upload video for recursive CTE in that concept I have little confusion

[@TechWithHema]

Sure @aravindhanc5087

[@josejoel9346]

Normalisation concept solli kodunga mam.

[@TechWithHema]

Sure @josejoel9346

[@top10infotamil64]

Windows functions full ha explain panunga

[@ravisudharshan]

need video for stored procedures

[@kodivicky7970]

Extraordinary

[@sabapathy4218]

Nicely explained

[@TechWithHema]

Thanks @sabapathy4218

[@akhil1964]

recursive in sql

[@vivekvasu5618]

just excellenttttt

[@sasisviewvlog]

Hi mam,
What is the major difference between temp table and cte ?

[@SudhakarSudha-p1y]

With CTE function....Oracle SQL application la use panna mudiuma?

[@HareeshBose-i7z]

examples la simple ah kudunga. unga example eh complex ah iruku. CTE basic theriyama vanthu pathn onume puriyala

[@srinii287]

Last epdi close pannanum... sister any close bracket or any symbol

[@TechWithHema]

Hi @user-wd6fi3ih8u CTE definition should be within the brackets.

[@ayyappanmani7669]

hlo maam sql interview qust theory ah iruka ?

[@TechWithHema]

@ayyappanmani7669 will make a video for that

[@vickynvt2545]

Plsql apis pls