|Subject||RE: [firebird-support] SELECT MIN|
> Hi! I have a 3 columns table: CLIENTID DATE1 DATE2if you want an aggregate/sum of date2 then
> for each CLIENTID can be more than one DATE1 so I have to select
> the MIN. Just doing this works fine:
> SELECT MIN (DATE1)
> from mytable
> group by CLIENTID
> Now I need also to show DATE2 in the result, if I include it in
> the SELECT I need to include it in the GROUP BY but if I do that
> I don't get the MIN(DATE1)for each CLIENTID: it returns all of them..
SELECT CLIENTID, MIN(DATE1), MIN(DATE2) FROM MYTABLE
GROUP BY CLIENTID
will do - if you don't want an aggregate/min/sum of a filed then your logic
Which, exactly, DATE2 value would you want adjacent to the clientid when
MIN(DATE1) is returned?