/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

4 votes291 views2 answers
Truncate oracle
SQL
11 votes312 views1 answer
Oracle export view ddl
SQL
0 vote310 views1 answer
C# sql transaction multiple connections
SQL
1 vote274 views1 answer
Postgresql blocked on mac
SQL
11 votes258 views2 answers
Sql rank
SQL
0 vote269 views1 answer
How to open mysql in docker
SQL
0 vote261 views1 answer
TITLE: SQL Server principal "dbo" does not exist
SQL
0 vote272 views1 answer
Big table in mysql
SQL
1 vote273 views2 answers
Check if word is in column sql
SQL
3 votes263 views1 answer
Oracle apex warning message
SQL