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

[@kedarnathk6326]

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

[@TechWithHema]

Thanks @kedarnathk6326

[@samphoenix1623]

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

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

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

[@karthickg4746]

Excellent explain ❤

[@thenuchellappen4688]

Very well explained thanks a lot sis

[@periasamy5563]

Very nice explanation of cte.

[@TechWithHema]

Thanks @periasamy5563

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

[@srinii287]

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

[@TechWithHema]

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

[@sasisviewvlog]

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

[@logamuthu7562]

I got the job because of your videos 🙏🏽

[@TechWithHema]

Glad to know that my videos helped you🙏 Congrats logamuthu

[@ravisudharshan]

need video for stored procedures

[@kodivicky7970]

Extraordinary

[@josejoel9346]

Normalisation concept solli kodunga mam.

[@TechWithHema]

Sure @josejoel9346

[@SudhakarSudha-p1y]

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

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

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

[@top10infotamil64]

Windows functions full ha explain panunga

[@vivekvasu5618]

just excellenttttt

[@sabapathy4218]

Nicely explained

[@TechWithHema]

Thanks @sabapathy4218

[@akhil1964]

recursive in sql

[@ayyappanmani7669]

hlo maam sql interview qust theory ah iruka ?

[@TechWithHema]

@ayyappanmani7669 will make a video for that

[@HareeshBose-i7z]

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

[@RajA-xs5zq]

Yes

[@vickynvt2545]

Plsql apis pls