SQL Server Programming Part 17 - The Pivot Operator

Подписаться 209 тыс.

Просмотров 71 тыс.

50% 1

If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link www.wiseowl.co... to make a donation. Thanks for watching!
By Andrew Gould
www.wiseowl.co.uk - The Pivot Operator in Microsoft SQL Server allows you to group data by columns, as well as by rows, to create simple static pivot tables. This video teaches you how to use the pivot operator including how to apply aggregate functions and, importantly, a quick method for listing out the column headings of your pivot table using the QuoteName function.
You can download the script to create the Movies database used in this video at the following link:
www.wiseowl.co...
You can view a written version of this tutorial at:
www.wiseowl.co...
You can see the range of resources and courses we offer in SQL Server here:
www.wiseowl.co...
Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio, SQL Server, Reporting Services, Analysis Services, Visual Studio, ASP.NET, VB.NET, C# and more!

Опубликовано:

4 окт 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 45

@Evan-tt5kk 6 лет назад

Finally someone who speaks clear English

@sahers3009 3 года назад

Such unnecessary comment!!

@bbvvi 4 года назад

Hands down - the BEST pivot tutorial on the internet!

@arturmostowiak9427 3 года назад

So far the best PIVOT explanation I have found

@WiseOwlTutorials 3 года назад

Thank you Artur, happy to hear that you found it useful!

@Moflia2 2 года назад

You are a genius for that creating that query that puts the brackets around the country names. It's almost like a cheat code haha!

@WiseOwlTutorials 2 года назад

😀 thanks Chris!

@HusseinALSHAMIRI 2 года назад

Thank you very much, straightforward and easy to follow

@WiseOwlTutorials 2 года назад

Happy to hear that you found it useful, thanks for watching!

@CRWork-p9z 10 месяцев назад

Thank you so much. I am learning, and this was helpful. Thanks for starting with the building blocks.

@WiseOwlTutorials 10 месяцев назад

You're very welcome, happy to hear that the videos are useful, thanks for watching!

@houstonfirefox 2 года назад

Great Tutorial! All of your videos are concise, to-the-point and enjoyable to watch. Thanks!

@WiseOwlTutorials 2 года назад

Thanks! Happy to hear you're finding the videos useful!

@gautamanand2117 7 лет назад

Your tutorials are very much explanatory than any else video. Great Job!!!!

@gautamanand2117 7 лет назад

Just wanted to know If Andrew and WiseOwl are on Twitter? Would suggest to put twitter handles in video description :)

@yurysambale 7 лет назад

Thank you, your explanation of the pivot operator was clear unlike my professor's

@notta3d 10 лет назад

Great video. Always wondered what QUOTENAME was for as well.

@geofff4011 5 лет назад

Just saved me hours of trial and error. Thank you!

@luisgraterolpalumbo3200 6 лет назад

This is the best video on Pivot Tables out there. Thanks!

@jasmineRodriguez-hg6di 9 лет назад

Great video on PIVOT operator. Thanks a lot :)

@wincentyzkielczy9162 6 лет назад

Very clear explanation. Thank you!

@ezedienkamal2471 3 года назад

this was an amazing explanation. thanks

@sugandhsai 10 лет назад

i owe you guys a lot ...........evergrateful

@jessicaerasmus7428 6 лет назад

Very helpful. Thank you so much

@RetroRick1990 8 лет назад

Very good, many thanks dude !

@janabaker4219 8 лет назад

After trying to learn how to pivot a SQL table from site after site...i almost gave up! You allowed me to nail it! Thank you! Question though...can you Pivot two things? I am trying to Pivot a Min(StartDate) and Max(EndDate).

@lolerpal 6 лет назад

Thank you hermano tengo parcial mañana y me estas salvando TUTUTUTUTUTUTUTUTu

@iqiddishnarmak 5 лет назад

Great explanation! Although, you could have explained pivots using a more simple example without joins.

@WiseOwlTutorials 5 лет назад

Thanks Kamran!

@dalecornplant6073 5 лет назад

love this

@oladman9058 Год назад

Wow!

@balaji.k.ramanar8107 8 лет назад

thanks really nice..

@RavikantRai21490 8 лет назад

Have you done one for UNPIVOT as well? Thanks for this one, I understood this well.

@ItsTarzan100 6 лет назад

Hey very useful video, thanks a tonne. Could you please suggest if i want to pivot using more than one aggregate columns, how do i do that ?

@fadwa2413 2 года назад

Andrew,I need a favor from you I need some links or videos to explain SQL for Query Tuning and Performance Optimization Thank You AND As always, you are Gift from Allah to US.God Bless You

@WiseOwlTutorials 2 года назад

Hi! I'm sorry but we don't have any videos on that topic at the moment. You'll find many examples with a quick Google!