SQL Server Programming Part 11 - Common Table Expressions (CTEs)

As usual for @WiseOwlTutorials, VERY well thought out and presented. Your later videos have the volume properly normalized to 50% volume. Nothing a quick hit of the volume knob can't fix while watching. Keep up the great work, a True Data Professional!

The simple, clear and consise explanation I was looking for. Thanks so much!

HI Team, your videos are really helpful and please make a videos on query optimization and execution plan in sql server

How can one get this database?

This was great. thank you very much , Please Can you make new videos about CTE?

Very easy to follow. Thanks so much!!!

This was great.
Love the way you explain. Would love to watch more detailed in depth tutorials for SQL where you explain these concepts.

thank you very much

This makes sense now! Thank you soooo much! ....I watched 30 min of videos before this and was nothing but confused. I watched 8 min of your video and you cleared all confusion

no word can explain the beauty of such simplified and full of knowledge videos...so amazing.. Love you.

Excellent. Thanks from BRazil. Very helpful your work.

So what would be the main difference between a CTE and a subquery with a table alias?

thanks, very cool

Great video, great explanation of very useful and helpful tool - CTE in SQL. Thanks a lot!

I love the way you explained everything, thank you so much.

Yeah I'm clearly too dumb. I get this example, but can't apply it to my homework. How the fuck did I make it to 6th Semester

I feel smarter already

Still not getting the purpose of all of this - why couldn't you just write inner joins, left outer joins, and subqueries... does this somehow improve performance? I'm continuing to look elsewhere, but if you could explain further why we need CTEs in our lives?? I would be very grateful!!!

Thank you Sir very clear explained !!

Hello, could you also add a video about query performance optimization and index better usage?

British accent = learning more SQL

I learned sql at my job and udemy but these videos are excellent.

I learned SQL from the Coursera but your videos are very practical and I can apply advanced SQL to my job. Thanks so much for sharing this.

Thansks for your explanation! Great!!

...like putting a warm knife through butter. Thanks a lot.

the whole series are explained very clean. thank you very much

Thanks Andrew. Very clear and practical!

This video plus the other videos are great.  Quick and straight to the point.  I think you said it before but do you have a link to the db so can also play with that data?

thanx a lot for this video

Can you tell me the difference between a CTE and a derived table?

Thank you for these videos - nice work Wise Owl !

Will CTe be a good way to reference a calculated field in a different select statement where usually that is not possible?

I LOVE THESE TUTORIALS.SO HELPFUL

This is good video of CTE and I enjoyed watching. But I have questions as below: 1. If a CTE name followed by column names as in selected, are these to be in the same order. ex.: cteEmp (col1, col2) (select col1, col2)? 2. How about prefixing cte in front of ctename 3. Same things are achievable by select statement then what is the advantages? which are not explained. Thanks

Good stuff