SQL WITH Statements (Common Table Expressions - CTE)

Thank you

Thank you. It was wonderful explanation

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

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

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

Thanks a lot for simple explanation

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

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.

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

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

Thanks! Liked, Commented and Subscribed!

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

Best explanation ever!! 👍

Very helpful..... Love from India

conceptual and easy way to describe

and, boom!

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

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

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.

Great explanation

Thank you for this very useful video!

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

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

Sweet and simple: thanks!

Thanks, easy and straight forward!

Nice video, thank you

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

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.

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

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

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

thankyou sir, it really helped me.

Great video!

hats off!!

Super sir 👍👍👍

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

Why the pc screen is so blurred?

Thanks!

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.

That was super helpful!

ahhh That makes it much clearer. Thank you!

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

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

Thanks! That was very helpful :)

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

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

This is great!

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