/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

1 vote120 views1 answer
Oracle explain plan
SQL
0 vote133 views1 answer
Show tables in cassandra cql
SQL
3 votes140 views1 answer
Oracle undo tablespace schema
SQL
0 vote137 views2 answers
Find lowest number in sql
SQL
0 vote148 views1 answer
Enlever les doubles espaces dans les tables postgresql
SQL
0 vote139 views1 answer
Rollback to name in sql
SQL
0 vote127 views1 answer
Mysql query single row
SQL
0 vote140 views1 answer
Alter check command
SQL
0 vote136 views1 answer
On sql table data exists
SQL
0 vote146 views1 answer
Start stop mysql linux
SQL