Re: [SQL] max question

2005-04-13 Thread Bruno Wolff III
On Tue, Apr 12, 2005 at 12:24:21 -0500, "A. R. Van Hook" <[EMAIL PROTECTED]> wrote: > I have the following in a table: > oid | citkey | contby | contdate | abcontinue | ccdate > -++--+++ > 5774835 | 04-0594703 |

Re: [SQL] max question

2005-04-12 Thread Dinesh Pandey
t: Tuesday, April 12, 2005 10:54 PM To: pgsql-sql@postgresql.org Subject: [SQL] max question I have the following in a table: oid | citkey | contby | contdate | abcontinue | ccdate -++--+++

Re: [SQL] max question

2005-04-12 Thread Tom Lane
"A. R. Van Hook" <[EMAIL PROTECTED]> writes: > I am trying to pull rows that have the max. contdate. Why does the > following give more than 2 rows? > ql "select oid,* from ccontinue where citkey ='04-0594703' group by > oid,citkey,contby,contdate,abcontinue,ccdate having max(contdate) = > cont

[SQL] max question

2005-04-12 Thread A. R. Van Hook
I have the following in a table: oid | citkey | contby | contdate | abcontinue | ccdate -++--+++ 5774835 | 04-0594703 | ||| 5775325 | 04-0594703 | Attorney | 04/06/2005 | 6 | 03