SQL Server training :- How to implement Pivot?

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

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

50% 1

Buy full Sql Server course from here www.questpond.com/learn-sql-s...
For more such videos visit www.questpond.com
For more such videos subscribe ru-vid.com...
See our other Step by Step video series below :-
Python Tutorial for Beginners:- • Python Tutorial for Be...
Learn Data Science in 1 hour :- tinyurl.com/y5o7qbau
Learn Power BI Step by Step:- tinyurl.com/y6thhkxw
Learn MSBI Step by Step in 32 hours:- goo.gl/TTpFZN
Learn Tableau step by step :- tinyurl.com/kh6ojyo
Learn SQL Server Step by Step tinyurl.com/ja4zmwu
Learn Angular tutorial step by step tinyurl.com/ycd9j895
Learn MVC Core step by step :- tinyurl.com/y9jt3wkv
Learn C# Step by Step goo.gl/FNlqn3
Learn Design Pattern Step by Step goo.gl/eJdn0m
Learn Azure Step by Step :- tinyurl.com/y6fmrech
Learn SharePoint Step by Step in 8 hours:- goo.gl/XQKHeP
In this video we will try to implement Simple Pivot function in SQL Server. So we will take a simple customer and product data and pivot them on the basis of customer name and product name.
FYI :- This is also one of those most asked question in SQL Server interviews.
We are also distributing a 100 page Ebook "Sql Server Interview Questions". If you want this ebook please share this video in your facebook/twitter/linkedin account and email us on questpond@questpond.com with the shared link and we will email you the PDF.

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

27 фев 2013

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

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

Do not miss our Interview Question video series 30 Important C# Interview Questions : ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-BKynEBPqiIM.html 25 Important ASP.NET Interview Questions : ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-pXmMdmJUC0g.html 25 Angular Interview Questions : ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE--jeoyDJDsSM.html 5 MSBI Interview Questions : ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-5E815aXAwYQ.html

@tjldsl 5 лет назад

Just found this now, but this is BY FAR the best explanation of SQL Pivot functionality. Thank you very much for a great video!

@chandanasoundararajan8790 Год назад

Thank you sir. One teacher can change entire world. you are doing it well. Thanks from bottom of my heart.

@danilchezz 5 лет назад

trying to figure pivoting for the last 2 days, I went to a dozen of sites and did not actually grasp the plonker until watching this video. Kudos for the explanation, sir!

@TheRoxas13th 10 лет назад

This clearly explained the PIVOT function. Thanks!!

@krismaly 9 лет назад

Function PIVOT explained well. I enjoyed watching the video and recommend to others. Thanks for educating the community and appreciate your volunteer-ship and efforts in producing this video. Please keep publish few more videos. Thanks a bunch

@CAVescera 10 лет назад

This video is freaking awesome! Thank you!

@atiqulny 10 лет назад

You made it very easy to understand. Thanks a lot!

@adamschneider4143 7 лет назад

Where talking exporting tens of thousands of records in mere seconds because of pivot my friend. extremely useful. thank you.

@waldof86 10 лет назад

thanks for the explanation, it was a very clear example

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

Greatest and simplest explanation, thank you

@niteshsharma3878 6 лет назад

Well explained sir🙏 thank you!

@shashankas100 10 лет назад

This is an excellent video. Thank you.

@FlashRiver 10 лет назад

Shiv, nice work... thanks

@DevlopmentHub 5 лет назад

Thnaks for Expalantion .it was very clear exapalantion

@nuthouse99 9 лет назад

Excellent tutorial

@mubashirgul7644 10 лет назад

excellent video....nicely taught...Thankyou

@RamKumar-kr9rh 7 лет назад

Sweet and simple....

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

Great explanation thank you so much

@dgowtham5290 6 лет назад

Great video sir

@zunaidhossain872 5 лет назад

Very nice... Thank you sir.

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

Great work bro

@Jerichoom 11 лет назад

Nice work sir, thank you for the help. 1st time I ever pivoted in SQL :)

@DevlopmentHub 5 лет назад

nice sir

@mauroldanr 6 лет назад

Excellent!

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

explained nicely...

@romeror1945 5 лет назад

Thank u for the videos

@amalchacko3566 9 лет назад

Thank You :)

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

Very nice video

@chugerich 5 лет назад

Thanks!

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

Thank you!!!

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

thank u

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

Nice explanation, how can we use same pivot operator function in MS access sql query?? Thanks in advance!!!

@jiturcm1 10 лет назад

Pivot with out aggregate function is possible

@yogeshcu7975 6 лет назад

Only for 2 values it is fine... What about if have N number values?... Do I need to write manually all columns in step 1... Is other way to workaround it

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

Hello after this can I save the unpivoted table in SQL Server?

@brnjnsvld 10 лет назад

What if we want both sum(amount) and count # of orders aka count(amount)? Also why can't I do: Pivot(count(*)... or Pivot(count(CustomerName)... {gives me invalid column name in the 2nd section}

@prasunjeetsoni6143 5 лет назад

tell me one thing .. if you have more than 100 product then u write 100 product hard code .. and day by day its increasing then your this method will fail .. please give solution for dynamic pivot

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

CREATE TABLE TESTPIVOT(CUSTOMERNAME VARCHAR(100),PRODUCTNAME VARCHAR(50),AMOUNT DECIMAL(18,3)); INSERT INTO TESTPIVOT(CUSTOMERNAME,PRODUCTNAME,AMOUNT) VALUES('SHIV','SHOES','100.230'),('SHIV','SHIRTS','200.340'),('RAJU','SHIRTS','145.670'),('GANESH','SHOES','908.000'),('GANESH','SHIRTS','98.000'),('JIGNESH','SHOES','987.000');

@zezeandjr4110 5 лет назад

I appreciate the content, but the word is Pivot, a short / quick "i" and a short / quick "o", not like the word Boat or goat, it's almost pivet, just a side note.

@zezeandjr4110 5 лет назад

I like the content, but the word is PIVOT, a short "i" as in Pin or Pill, thus Pivot, not Piivot, just a side note.