matrix query - problem
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: matrix query - problem

  1. #1
    Join Date
    Jul 2006
    Posts
    96

    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

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,968
    Quote 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
    this space intentionally left blank

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width