How to write a sql query to get this result?

From: "Daniel" <postgresql(at)dunajsky(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: How to write a sql query to get this result?
Date: 2003-05-01 03:31:20
Message-ID: 020601c30f92$22174ca0$0300a8c0@akssk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello,

Is there any way how to retrieve result normally displayed as:

TOTAL 268
Administrator 7
Internet Only 178
Filtered Internet 7

To be like this:

TOTAL Administrator Internet Only Filtered Internet
268 7 178 7

That means, the rows of the first column of the first case are headers in
the second case. Similarly, the rows of the second column are displayed as
one row.

Please reply to daniel_katka(at)hotmail(dot)com

Thank you very much.

Daniel

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Ramesh PAtel 2003-05-01 06:36:07 Date Problem
Previous Message Daniel Dunajsky 2003-05-01 03:07:50 How to write an query to get this result?