/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

7 votes145 views2 answers
3rd height salary sql
SQL
0 vote129 views1 answer
Sqlite3 now
SQL
6 votes136 views4 answers
How to remove unique key in mysql
SQL
2 votes97 views1 answer
Sql float to int
SQL
0 vote136 views1 answer
Sql date d'aujourd'hui
SQL
4 votes146 views1 answer
Mysql biginteger size
SQL
1 vote137 views1 answer
How to install mysql 8.0 windows service
SQL
0 vote156 views1 answer
Tablas bootstrap responsive sql server para datos vivos
SQL
17 votes146 views2 answers
T_sql contains
SQL
0 vote173 views1 answer
Mysql error codeigniter
SQL