Guys

       Suppose the query is

                  Select count,premuium,state from tABLE1

      and the O/P comes in this format

      ------------------------------------------------
       COUNT PREMIUM STATE
      ------------------------------------------------
        0 100 AT
        4 888.99 CD
        2 09 NE
        0 0 CA
      ---------------------------------------------

 But i want the result to be in this new format like given below


          ---------------------------------------------------

          ---------------------------------------------------

 state AT CD NE CA

 count 0 4 2 0

 premium 100 888.9 09 0

             -----------------------------------------------------



  Does anybody know how to do this...

look for pivot table or cross-tab query in your database help files.

try youself atleast..

Thanks shahchi...........It worked.