-
matrix query - problem
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
-
Originally Posted by madhugp
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 query
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|