Register at the below link to get US $100 off for Coursera Plus membership between Sep 8 - Sep 29, 2022. The Coursera Plus membership gets you access to unlimited courses and unlimited certifications! imp.i384100.net/Ke51on
@sylvia38202 жыл бұрын
Outstanding!! Was in a hurdle and thanks to you I was able to finish my report at work . Thank you so much for your teaching ❤️
@LearnatKnowstar2 жыл бұрын
Glad it was helpful 🙏
@rajkotipatelgunishetti88136 ай бұрын
Outstanding ,it was clear as expected
@LearnatKnowstar6 ай бұрын
Glad it was helpful.
@kamskamundu67202 жыл бұрын
Thanks very much. Then m'y question IS that how to join this pivot function with and other query in order to get opennning balance in report.
@Shashankgupta004Ай бұрын
@LearnatKnowstar Thanks for sharing such an amazing method of pivoting rows into columns but i have a question here , what if we want to execute similar operation with columns to rows then how it would be possible as columns name are not stored anywhere which can be called in pivot function. Please advise.
@sholland422 жыл бұрын
Nice presentation. Try hitting ctrl-shift-r to refresh the intellisense cache and the red squigglies go away.
@haederoth2 жыл бұрын
Hello. If someone can help --> What code lines need to be added in order to copy the result of this query into an other table of the database ? Many thanks !!!!
@vishalransing953110 ай бұрын
Superb explanation
@LearnatKnowstar10 ай бұрын
Thank you 🙂
@navyavs79022 жыл бұрын
How to do this in sql oracle 12g?
@persianimmortal76423 жыл бұрын
You explain sql query very meaningful
@LearnatKnowstar3 жыл бұрын
Thank you
@SandeepTiwari-yy4fg Жыл бұрын
how to make zero(0) if salary is null or how to use ISNULL function here
@vidyak86385 ай бұрын
Can you please explain same query for Oracle sql
@hv00321133 жыл бұрын
You make it so easy to understand. Thank you.
@LearnatKnowstar3 жыл бұрын
Thank you
@Anaya-un4ge2 жыл бұрын
This is really good!! Thankyou for making it so easy to understand. I have a question. What if the Emp table is continuously getting new data every 15 mints. Would it be possible to do this without doing it from scratch everytime?
@shailendrakushwaha21302 жыл бұрын
error while using string_agg function in sql server 2012: 'STRING_AGG' is not recognized built-in function name. pls help
@LearnatKnowstar2 жыл бұрын
You need to try alternate approach. SET @cols = STUFF((SELECT distinct ',' + QUOTENAME(c.Name) FROM dbo.Empl1 c FOR XML PATH(''), TYPE ).value('.', 'NVARCHAR(MAX)') ,1,1,'') To understand how this works, you can check the below video tutorial - kzbin.info/www/bejne/l3WrZYtoo81sY5o
@LearnatKnowstar2 жыл бұрын
You can also check out this forum - stackoverflow.com/questions/10404348/sql-server-dynamic-pivot-query
@nimeshkotadia6526 Жыл бұрын
Above method breaks down when i already have where condition with dates or names which already uses ' ' to convert to string. Any help around this would be helpful. Dynamic pivoting with where condition in the base query.
@petermaina7111 Жыл бұрын
You are a practically great
@LearnatKnowstar11 ай бұрын
Hope this was helpful.
@alwayschandra3 жыл бұрын
Nice explanation and very easy to implement . Thank You
@LearnatKnowstar2 жыл бұрын
Glad you liked it
@haederoth Жыл бұрын
UP. If someone can help --> What code lines need to be added in order to copy the result of this query into an other table of the database ? Many thanks !!!!
@francois749110 ай бұрын
Brilliant. Very helpful, thank you so much!
@LearnatKnowstar10 ай бұрын
Glad it was helpful!
@miasp786 Жыл бұрын
How to sort the column using this query
@scvrive2 жыл бұрын
thank you that was great , i want to combine fields from 2 more tables , lets say name was an ID to employee table andin the employee table there is a Dept ID linking to the department table , do you have another example i can watch to develop a multi table example
@StefanoVerugi2 жыл бұрын
excellent explanation, many thanks
@LearnatKnowstar2 жыл бұрын
Thank you so much
@johnghirardi Жыл бұрын
This was really useful and easy to follow. Thank you so much for sharing your knowledge! :)
@LearnatKnowstar Жыл бұрын
Glad it was helpful
@tnmyk_ Жыл бұрын
Amazing explanation! Thank you very much!
@LearnatKnowstar Жыл бұрын
Glad it was helpful!
@aswinkumar97513 жыл бұрын
Great work madam.i really appreciate it ☺️☺️
@LearnatKnowstar3 жыл бұрын
Thank you
@satyamsinha5429 Жыл бұрын
I have 1 question for pivoting
@PrakashPraaku7 ай бұрын
AMAZINGGGGG!! 👌👌👏👏
@LearnatKnowstar7 ай бұрын
Thanks!!
@nimeshkotadia6526 Жыл бұрын
how to execute the @sql into a temporary table? Basically, I am trying add a column for Total.
@saket2006 Жыл бұрын
This is extremely helpful - thank you for sharing.
@LearnatKnowstar Жыл бұрын
Glad it was helpful.
@hesam46 Жыл бұрын
Thank you for this great video. How can I get the Demo database to replicate what you do?
@saisubramanian6908 Жыл бұрын
excellent article and helped to move forward
@LearnatKnowstar Жыл бұрын
Thank you
@zeeshanazeem5212 Жыл бұрын
Excellent Work. works like a charm,
@LearnatKnowstar Жыл бұрын
Glad it was helpful.
@sourabhpatil23612 жыл бұрын
Mam one Question I we want one particular name at top and other remaining names down the top name then what is query for that?
@bhargavigogulamudi2758 Жыл бұрын
Can you please explain how to convert rows into columns dynamically in postgresql?
@kartik-wi2jv3 жыл бұрын
Mam.. your personal audio added in between.. plz take care..
@LearnatKnowstar3 жыл бұрын
Thank you for pointing it out. Reedited the video. Thank you.
@kartik-wi2jv3 жыл бұрын
@@LearnatKnowstar thank you so much mam for sharing your knowledge..
@aneelt9193 ай бұрын
Awesome.
@LearnatKnowstar2 ай бұрын
Thank you
@surik9722 жыл бұрын
Thanks a lot madam for all ur efforts!! Do u have any plans to start the oracle plsql concepts
@LearnatKnowstar2 жыл бұрын
Glad it was helpful. We are definitely planning it in the future. Stay tuned and Subscribe 🙂
@sunilshinde9897 Жыл бұрын
Awesome.Thank you mam.its great Tut.
@LearnatKnowstar Жыл бұрын
Thank you
@leolitvinsky41392 жыл бұрын
order by is not allowed in subquery.
@gregorybuiche50842 жыл бұрын
Gregory Buiche Nice explanation. Is there a way to make the same job without STRING_AGG for users of SQL SERVER 2014 😢
@LearnatKnowstar2 жыл бұрын
Thank you. You can try using 'for xml' and stuff. It is explained in the below video - kzbin.info/www/bejne/l3WrZYtoo81sY5o
@shaiprabudhanasekaran78802 жыл бұрын
Ma'am How to remove the space in between each Column Names.
@sanjaysunilkumar36742 жыл бұрын
very good tutorial
@LearnatKnowstar2 жыл бұрын
Thank you!
@ismaelobligacion7531 Жыл бұрын
Please comment here your whole query..,thank you,,
@melissawareham74292 жыл бұрын
fabulous, very helpful, thank you!!
@LearnatKnowstar2 жыл бұрын
Thank you so much!
@ninhduongchan7632 жыл бұрын
which is the type of ''value''?
@ninhduongchan7632 жыл бұрын
What is the 'value'?
@LearnatKnowstar2 жыл бұрын
Value is a column name in the original table.
@terryh5582 жыл бұрын
Awesome!😊
@LearnatKnowstar2 жыл бұрын
Thank you 🙏
@jeromevanbeek90702 жыл бұрын
How do you do this with MySQL?
@tusharjadhav69402 жыл бұрын
Hello mam , i have one string (my|name|is|tushar|abc|ahha|haha|hshs) I already separated it using create function which is similar like string_split because i have old version of server, So sir , i have table which contains 8 columns col1,col2,col,3 I have to insert the seprated string values into this columns(8 columns are their) I am seprated it but they are form rows My Name Is Tushar Like that i need to insert into columns or horizontal way. And its completely dynamic Can you help me out???
@ninhduongchan7632 жыл бұрын
why is the "value" blue?
@sholland422 жыл бұрын
It’s a SQL keyword
@capitalInd3 жыл бұрын
Declare @HOD Nvarchar(max); Declare @Sql Nvarchar(max); set @HOD= (select STRING_AGG([HOD Name],',') from (select distinct [HOD Name] from Dealer)a); Set @Sql = 'select' + @hod + 'from (Select [HOD Name] from Dealer) as Src_Table Pivot (count([HOD Name]) for [HOD Name] in ( ' + @HOD + ' )) as pvt' execute (@sql) AFTER EXECUTE SHOW ERROR = Msg 102, Level 15, State 1, Line 4 Incorrect syntax near ','. Msg 156, Level 15, State 1, Line 5 Incorrect syntax near the keyword 'as'. PLEASE HELP
@LearnatKnowstar3 жыл бұрын
You can try printing @sql text and check for any syntax errors. It could be due to missing spaces around the @col values that you have inserted.
@capitalInd2 жыл бұрын
@@LearnatKnowstar printing @sql text working fine but giving error while executing @sql check printing @sql text select Aashish .,Ajit Kumar Singh,Anup Kumar Chaudhary,Ashutosh Goutam,Bhavesh R Kanadiya,Brijender Kumar,Deepak Chaudhary,Gautam Singh,Juned Niyaj Ahmad,Madhu . Kashyap,Mayur Tarachand Purohit,Mohammad Khalid,Mohd Danish Shaikh,Mukesh Kumar Ray,Pankaj Kumar Singh,Piyusha Satish Kotkar,Ritesh Kumar Sinha,Sani Kumar Kanojia,Suman Kumar,Tahseen Raza Khan,Tribhuwan Narayan Pandey,Varun Ashok Sharma,Vivek Kushwahafrom (Select [HOD Name] from Dealer) as Src_Table Pivot (count([HOD Name]) for [HOD Name] in ( Aashish .,Ajit Kumar Singh,Anup Kumar Chaudhary,Ashutosh Goutam,Bhavesh R Kanadiya,Brijender Kumar,Deepak Chaudhary,Gautam Singh,Juned Niyaj Ahmad,Madhu . Kashyap,Mayur Tarachand Purohit,Mohammad Khalid,Mohd Danish Shaikh,Mukesh Kumar Ray,Pankaj Kumar Singh,Piyusha Satish Kotkar,Ritesh Kumar Sinha,Sani Kumar Kanojia,Suman Kumar,Tahseen Raza Khan,Tribhuwan Narayan Pandey,Varun Ashok Sharma,Vivek Kushwaha )) as pvt PLZ HELP HOW TO RESOLE THIS ERROR
@TheRaju9912 жыл бұрын
@@capitalInd I know it's been a very long time. But there was a typo at this line with two closing parenthesis )) Pivot (count([HOD Name]) for [HOD Name] in ( ' + @HOD + ' )) as pvt' so fix should have been only: Pivot (count([HOD Name]) for [HOD Name] in ( ' + @HOD + ' ) as pvt'