CTE (Common Table Expression) IN SQL With Examples| ADVANCE SQL TUTORIAL

[@swarnimap2115]

shortest video on CTE I came across yet so beautifully explained

[@ukakekakuk]

This is the most simple example i found on youtube, Thank you

[@andyn6053]

Very easy to understand when you explain like this with examples. Thanks u are a life saver 😊

[@DiptarunChatterjee]

Just head up to msdn documentation.. XD

[@Nikhilg-rs7iv]

thank you so much for explaining in a simply way and some others messes up after half of the query. you handled it well

[@crackconcepts]

Glad it was helpful!

[@LakshmiHarika-y2g]

Great explanation mam i understood very well .

[@lkkota41]

thank you.. finally understood what cte is

[@JyothiRoyal9618]

Thank you so much, you have explained it very clearly and in a simple mannar it is very easy to understand thank you so much once again. You made my work very simple🤗☺

[@bakthapuri]

Started watching your videos from couple of hours before and I love the way your explanation, easily understanding.. Thanks for sharing

[@danielestrada2955]

So, common table expression might be used in the same situation as subqueries, but it allows other users understand easily my main query?
Good video!

[@Komalverma-j8t]

Thank you to explain CTE clearly. 🙂🙂

[@SanjayKumar-rw2gj]

Video helped me to understand CTE kudos to you for making this video and teaching CTE in very simple words with a sample query. You mentioned that we can create multiple CTEs and later can use it in select clause so can you make a video explaining how to use it.

[@abhinavsharma1374]

Thanks a lot dear you really solved my query... i.e max. Of total marks got by student

[@kanthiswaroopsanagapalli5433]

Thanks for your video, will you make video on difference between CTE and subqueries?

[@7smessi803]

Awesome simple explanation🎉

[@sajalshrivastava2202]

Very well explained ma'am 👍

[@akshayaseetharaman5687]

Nicely explained 👏 thanks much!

[@apostleisaacopokuagyeman5676]

Very useful example. Thank you

[@merlinelizabethmathew982]

Could you please do a video on CTE Vs View Vs subquery.

[@sowmya3584]

One small doubt...For the second example @5.00, can the query be written without cte like this...
SELECT dept_id, MAX(AVG(sales))
GROUP BY dept_id
FROM employees
Will this code alao give the same output??

[@islamandthelife]

Excellent tutorial please complete the tutorial series

[@prashantp9029]

Please upload video regarding collections and different types of indexing with live example

[@LogarPassport]

Very easy explained

[@lancelotdsouza4705]

Very well explained

[@kabilanmuthukrishnan7494]

Thankyou for the video more to come

[@jordanbpetersoninhindi198]

Nicely Explained!

[@mohammedasif4349]

Please upload video using multiple CTEs in single command.

[@vikasrana922]

Thanks mam this video is very good 👍

[@sriramnavin4975]

Thank you so much..You r the best ever..!!!

[@prabhakarsharma5556]

hey sadia make video on subquies, multiple row subquies

[@vikrantheswar7685]

Hi, can we use a cte inside another cte just like subqueries?

[@teefirdaus]

Another awesome video. Thank you ! Keep it up

[@waseembari2125]

Good explanation

[@roro47308]

Very clear , thanks

[@inolusca]

reaally nice! obrigado

[@smitkumarshah6947]

I understood very easily 😅

[@priyadarshivyas2233]

Good video

[@AjaySharma-cx9zw]

Good video. Please also make video in hindi. So many people not understand perfectly.

[@techninja9461]

excellent explanation!!

[@ajaykiranchundi9979]

Good video!

[@cricketupdate1909]

Thank for the session

[@chakrapanig6243]

Thank u so much ❤

[@leogodofnone2706]

Thanks 👍🏻

[@gidiyup]

Perfect!

[@LogarPassport]

Thank you ❤

[@sachitkorgaonkar9879]

What is the diff between cte n. Table variable

[@rohanbhandari7796]

Awesome thanks

[@RamRam-ce2yk]

Thank you..

[@sachinvithubone4278]

Good explanation.
Without CTE we can get the MAX sales right?
1. Is cte very fast compare to other SQL quer?
2.If I do without cte SQL create any view table some where?

[@sst794]

First to watch

[@mohammedmanna3488]

Thank you

[@Pooja-b5w2z]

How can I contact you..I need a solution actually

[@venkatashish7340]

i want cte with inserting details

[@adinarayanakelli6812]

Tq mam

[@mikem2246]

2 LIKES ✌

[@bhanupratapsinghamuley1278]

thank you @crack_concepts to explain us in this simple way

[@shankarsr1]

Awesome thankyou