/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

6 votes123 views2 answers
Where clause in sql
SQL
0 vote107 views2 answers
Zsh: command not found: mysq
SQL
0 vote107 views1 answer
Optimize sql query
SQL
2 votes105 views1 answer
Check isolation level in mysql
SQL
16 votes113 views4 answers
Ascending order mysql
SQL
1 vote98 views1 answer
How to get mysql db size
SQL
0 vote107 views1 answer
How to count with except in psql
SQL
0 vote101 views1 answer
Docker export psql sql
SQL
0 vote128 views2 answers
Suse stop MySQL
SQL
0 vote135 views1 answer
Sql quary stuf
SQL