/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 vote117 views2 answers
Temp tables in sql server
SQL
0 vote139 views1 answer
Synapse sql table set pk
SQL
2 votes102 views1 answer
Sql to char function with date
SQL
0 vote123 views1 answer
Search starting with mysql
SQL
0 vote115 views1 answer
Transaction database with php
SQL
0 vote116 views1 answer
Get only one row in mysql
SQL
6 votes120 views2 answers
Postgresql restore from dump
SQL
0 vote144 views1 answer
Suhaib
SQL
23 votes127 views1 answer
How remove column in mysql
SQL
1 vote112 views1 answer
Get rows affected mysql python
SQL