/SQL/Convert rows into columns in oracle

Convert rows into columns in oracle

SELECT * FROM
( SELECT column1,column2
FROM
tables
WHERE conditions
)
PIVOT
(
aggregate_function(column2)
FOR column2
IN ( expr1, expr2, ... expr_n ) | subquery ) 

order by expression[asc | desc];

Source: doyensys.com

Similar codes

0 vote215 views2 answers
Postgresql get long running queries
SQL
0 vote235 views1 answer
FILENAME /usr/bin/mysql does not exists. Make sure correct path is set in /etc/dump admin/settings.conf.
SQL
1 vote222 views1 answer
Tsql random number
SQL
0 vote219 views1 answer
How to define a save method in ruby for sql databases
SQL
1 vote232 views1 answer
Oracle turn off constraint
SQL
0 vote238 views1 answer
Set root password mysql xampp
SQL
0 vote229 views1 answer
Complete date is 1 year or not sql server
SQL
0 vote240 views2 answers
How to take recent row without limit in mysql
SQL
18 votes221 views3 answers
'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004',
SQL
1 vote195 views1 answer
Python escape string for sql
SQL