I'm basically a Oracle programmer and now working on DB2. I have a requirement to show rows in column. I used to use DECODE function in oracle to do that. Is there a way in DB2 to display rows in column fashion.
For Ex:
Dept Name Total Employees
----------- ---------------
Finance 22
WareHouse 70
Production 50
I want to show the above data in query as follows (just using plain SQL)
Finance WareHouse Production
22 70 50
Please help me..
Sat
For Ex:
Dept Name Total Employees
----------- ---------------
Finance 22
WareHouse 70
Production 50
I want to show the above data in query as follows (just using plain SQL)
Finance WareHouse Production
22 70 50
Please help me..
Sat