SQL WITH Statements (Common Table Expressions - CTE)

Step-by-step tutorial shows you how to use the WITH statement in SQL to create Common Table Expressions (CTE)!
Watch the Subquery video: • How to do Subqueries i...
Get the Northwind Database: • How to Load a Sample P...
Support the Channel:
1) Subscribe:
2) DataCamp:
3) Udacity:

[@roodyg5352]

Thank you! This video helped me understand CTEs a little bit better.

[@Findawaytomak3it]

Dude! thank you for taking the time to break down cte's simplified (subquery >> cte). Bro, you rock!!! 😎🤟

[@meanpillscasper]

Just a small correction, using the with statement makes indeed things easier to read and debug but the program won't be any faster. It's just a thing you should do to help other humans understand your code.

[@lalifali8426]

You explained it so well and fast I'm now fully prepared for what may come

[@jude3026]

U ROCK. im going through your channel and god you couldnt get less helpful. thanks man

[@atothezeezee]

This was excellent - thank you.

[@vikrantyoung4868]

Simple and easy to understand explanation. It really made understanding the WITH statement so simpler. Thanks much.

[@ChrisShepperd]

The way you describe what cte's are made all the difference. It's so simple when you know yhe why for the how.

[@amare_._]

This is clearer than my textbook explanation lol thanks for the video!

[@Tushelek]

Thanks, mate! Your explanation is very easy to understand.

[@salsaica2]

Thank you for the video, very clear, I like the format, it's straightforward and very well explained!

[@waldojams]

Thanks for the video. I was looking for more info about caching, but noticed (after some reading) that the caching doesn't happen because of the CTE, but instead, it's decided arbitrarily by Postgres. So for instance, either doing subqueries or CTEs might result in the same performance in the end, even though CTEs makes code more readable.

[@marcinbednarz9488]

Hi Nathan, thanks for explaining me CTE Objects. It's know very clear to me. Appriciate

[@송예은-h7b]

Best explanation ever!! 👍

[@alexg97343]

Great explanation

[@123arskas]

Thank you. It was wonderful explanation

[@BilalAli-gr3ry]

Very helpful..... Love from India

[@ViraSpasivska]

Thanks a lot for simple explanation

[@higiniofuentes2551]

Thank you for this very useful video!

[@tauseef_khawaja]

conceptual and easy way to describe

[@snipezu805]

Thanks, easy and straight forward!

[@jundolor4013]

Great video! This helped me run a complex query at work. Thanks 😀

[@gomojo1024]

Thanks! Liked, Commented and Subscribed!

[@RodrigoCruz-iz3kb]

Your video helped me a lot, thank You my friend!

[@yeoshuabenzaken7736]

in the 3rd example nothing changed when you joined another cte. So why did you join them?

[@ukaszk.8305]

You are a sensation! Please, keep going :)

[@tamaramattson4768]

How can I union two cte together, there is one sum on a budget, column are exactly the same I have group by , send me video please

[@danielmejia8530]

Nice man! subscribing.... Greetings from Colombia!

[@jilliansolomon1178]

Thankful for your videos - super helpful! Do you have to use a GROUP BY clause when using CTE's?

[@houstonfirefox]

It's not a requirement but you certainly could

[@VeronicaAngryPolak]

why did you use "using" in your join statement and not "on"?

[@josemarino4270]

Sweet and simple: thanks!

[@Lashistoriasdelilith]

I don't understand what the ctdorders have inside...

[@hasanmougharbel8030]

hello there, god bless your efforts..I have a simple enquiry as new sql learner. How are CTEs different from temporary tables? Thanks for taking care of this.

[@houstonfirefox]

A temporary table will exist during the entire duration of the session whereas a CTE is a "named result set" that exists for the duration of the statement immediately following it. If you would like to persist the results of the CTE, then use the CTE to populate a temporary table for processing later. Hope this clears things up

[@zhiyizhang9102]

great example and explanation!

[@andyn6053]

what is the difference between cte:s and temp tables? temp tables are only stored temporarly and cant be accessed as an cte?

[@TheBeanzo]

ahhh That makes it much clearer. Thank you!

[@larryhatcher8927]

I've been studying SQL now for about 6 months....I think the CTEs are really a good place to start but the more knowledge you gain the more you tend to move away from them and use subqueries

[@houstonfirefox]

Congrats on your learning Larry. Like all tools, CTEs, subqueries and cursors all have their appropriate use cases. While it is true that you could program almost everything using subqueries, other methods (such as CTEs) could be used as well to make your code easier to follow for those coming behind you to maintain it. Like a painting, everyone has their own style and choice of tools 😉

[@daniellakshan]

thanks bro, you saved a lot of time

[@shujaatali4728]

Nice video, thank you

[@amberjones6191]

That was super helpful!

[@mikesizemore5939]

Great video!

[@mabblers]

Excellent explanation . How dose work when you're working with 10 tables and 5 has millions of records in them? Is this viable considering this is all done in memory? Thanks

[@houstonfirefox]

In most database systems, the 'name' of the CTE simply references an internal temporary table that is invisible to you (unless you select from it). So, in effect, the results of the CTE will create a temporary table behind the scenes in order to hold the results of the CTE. It is deleted automatically when you go out of scope of the CTE.

[@hereandnow8578]

clear and concise. ty

[@moisefonguendegue5078]

Good explanation. God bless you. AMEN.

[@smz3610]

You have a crypto channel too?! I have seen your YF vids

[@ericsims3368]

Super helpful - thanks a bunch!

[@soseofficial3923]

thankyou sir, it really helped me.

[@lightoficeberg]

Thanks! That was very helpful :)

[@manideepgupta2433]

Finally!! Whoa! Thanks man.

[@oualidben5660]

Very clear, Thank You Sir !

[@meshari_27]

Thank you

[@hari7027]

Can I pass list of acctnumbers in with and it will traverse through each one of them to fetch acctid from diff table

[@crotteverte7496]

3:29 is the main purpose of CTE : OPTIMISATION An EXPLAIN of both syntaxe would have revealed it. Over code simplification, when you need to interprete subqueries results CTEs are way faster than subqueries since de BDD engine build the CTE result (in bdd server memory not cloud lol) ONCE en start with it for interpretation.

[@TheCazz10]

I didn't think CTE's are stored anywhere... temp tables are

[@ghinwamoujaes9059]

This is great!

[@superfreiheit1]

Why the pc screen is so blurred?

[@vitalykolesov9434]

Hvala puno!

[@factorise001]

hats off!!

[@deepakms5918]

Super sir 👍👍👍

[@alecdelu83]

Thanks!

[@haramrit09k]

Definitely helpful! Thank you for this. Can you also do a video on recursive CTEs?

[@anthonyedison2388]

i know Im kinda off topic but does anyone know a good site to watch new movies online?

[@kamerondeacon3657]

@Anthony Edison I use FlixZone. Just google for it =)

[@jaxonatlas1592]

@Kameron Deacon yea, I've been watching on FlixZone for since april myself =)

[@anthonyedison2388]

@Kameron Deacon thanks, I signed up and it seems to work =) I really appreciate it !

[@kamerondeacon3657]

@Anthony Edison happy to help xD

[@adridesu1]

I don't see the point of using WITH for a single query. If you would use the same WITH for multiple queries, I can understand how it helps.

[@christiangrundemann9843]

why no disclaimer to be careful/avoid using temp tables

[@paradix847]

Could you elaborate on why one should be careful using temp tables?

[@christiangrundemann9843]

@@paradix847 scope, memory and performance issues. if a temp table isn’t dropped and the client makes another request to the server, the temp table that was not disposed correctly can throw ambiguous errors

[@paradix847]

@@christiangrundemann9843 Hey that's good to have in mind. Thanks for the explanation.

[@gotchihaeyo1825]

Cte isn't tepm table. It works like a temp table. That's what I know. So no disclaimer.

[@sheenabian9368]

and, boom!