pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Waruna Geekiyanage <waruna@nirmani.com>
To: pgsql-php@postgresql.org
Subject: Re: max and sum function
Date: Mon, 24 Mar 2003 12:09:06 +0600
Message-ID: <002201c2f1cc$0c58be00$0c00000a@ibm1> (raw)
References: <1048391256.3e7d2e58a80b9@mail.up.edu.ph>


SELECT MAX(aa.res) from ((select sum(col1) as res from table group by id)
UNION
(select sum(col2) as res from table group by id)
UNION
(select sum(col3) as res from table group by id)) AS aa;
----- Original Message -----
From: "ryanne cruz" <ryanne.cruz@up.edu.ph>
To: <pgsql-php@postgresql.org>
Sent: Sunday, 23 March, 2003 9:47 AM
Subject: Re: [PHP] max and sum function


hi list.

does anyone here knows of a function that is similar to the sum function but
involves more than one column? for example, i have a table with columns id,
col1, col2 and col3. i want to get the max value from the three columns
gruped
by an id.

what i came up with is something like this:

max1=select max(one) from (select sum(col1) as one from table group by id);
max2=select max(two) from (select sum(col2) as two from table group by id);
max3=select max(three) from (select sum(col3) as three from table group by
id);


then i compare the 3 max values and get the maximum of the 3.

is there an easier way to do this?

thanks.

ryanne



---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly




view thread (3+ messages)  latest in thread

Message-ID: <002201c2f1cc$0c58be00$0c00000a@ibm1>
Permalink:  ../002201c2f1cc$0c58be00$0c00000a@ibm1/
Also on:    postgresql.org/message-id/002201c2f1cc$0c58be00$0c00000a@ibm1

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-php@postgresql.org
  Cc: waruna@nirmani.com
  Subject: Re: max and sum function
  In-Reply-To: <002201c2f1cc$0c58be00$0c00000a@ibm1>
  References: <1048391256.3e7d2e58a80b9@mail.up.edu.ph> <002201c2f1cc$0c58be00$0c00000a@ibm1>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox