Oracle Transactional Business Intelligence

Products Banner

Transpose using SQL PIVOT

35
Views
0
Comments

Content

I know you can transpose using SQL pivot. But to use PIVOT you need to use an aggregate. In some situations you dont want to use an aggregate. eg: what if you want to show the value in separate rows? How do you transpose in such situation?