Mark_Co
asked on
Request for help to use PIVOT and UNPIVOT
I've never used pivot before and I'm trying to learn how to use it. i'm not finding any helpful beginner examples that are easy for me to understand on the web. Can anyone show me any cool tips and tricks and just how I can use PIVOT and UNPIVOT?
I attached a picture of a sample table in my schema for you to give me some cool example SQL code I can mess with for using pivot and unpivot. Thanks
I was trying this for example but it's not right:
I attached a picture of a sample table in my schema for you to give me some cool example SQL code I can mess with for using pivot and unpivot. Thanks
I was trying this for example but it's not right:
select
*
from EMPLOYEES a
PIVOT
(SUM(salary))
tem.png
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER