Quick Links

MAX(column1),MAX(column2),...

From:	Bjarte Aagnes <bjartea(at)student(dot)sv(dot)uio(dot)no>
To:	<pgsql-sql(at)postgresql(dot)org>
Subject:	MAX(column1),MAX(column2),...
Date:	2002-04-15 18:38:12
Message-ID:	Pine.SOL.4.33.0204151932060.6621-100000@ulrik.uio.no
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-novice pgsql-sql

Hi,

How do I list all column names and maximum values for each column in a table.
I can list the column names, but can't see how to get the maximum of each
column without typing max(name) for every column.

Regards
Bjarte Aagnes

In response to

Re: data order problem at 2002-04-15 15:46:46 from Josh Berkus

Responses

Re: MAX(column1),MAX(column2),... at 2002-04-15 19:34:14 from Josh Berkus

Browse pgsql-novice by date

	From	Date	Subject
Next Message	Joshua b. Jore	2002-04-15 19:29:57	Re: SQL-Dump and refertial Integrity
Previous Message	Stephan Szabo	2002-04-15 17:45:09	Re: data order problem

Browse pgsql-sql by date

	From	Date	Subject
Next Message	Bruce Momjian	2002-04-15 19:13:28	Re: oid and oidvector
Previous Message	Stephan Szabo	2002-04-15 17:45:09	Re: data order problem