is it possible to write a matrix query using select
statement.
e.g to display job titles as horizonal rows, deptnos as vertical
columns and total salary as cells from emp table.
10 20 30
clerk 6000 40000 9000
officer 30000 24000 7000
Printable View
is it possible to write a matrix query using select
statement.
e.g to display job titles as horizonal rows, deptnos as vertical
columns and total salary as cells from emp table.
10 20 30
clerk 6000 40000 9000
officer 30000 24000 7000
Are you talking about a pivot query??? If you are take a look at this asktom post, pivot queryQuote:
Originally Posted by madhugp