Re: MAX(column1),MAX(column2),... - Mailing list pgsql-sql

From Josh Berkus
Subject Re: MAX(column1),MAX(column2),...
Date
Msg-id web-1371121@davinci.ethosmedia.com
Whole thread Raw
In response to MAX(column1),MAX(column2),...  (Bjarte Aagnes <bjartea@student.sv.uio.no>)
Responses Re: MAX(column1),MAX(column2),...  ("Travis Hoyt" <thoyt@npc.net>)
List pgsql-sql
Bjarte,

> 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.

That is exactly what you have to do.   I do not understand the problem.If you are looking for some way to save yourself
typingthe column
 
names, it doesn't exist.

-Josh Berkus


pgsql-sql by date:

Previous
From: Bjarte Aagnes
Date:
Subject: MAX(column1),MAX(column2),...
Next
From: "Travis Hoyt"
Date:
Subject: Re: MAX(column1),MAX(column2),...