Author Alejandro Garcia
Hi! I have a 3 columns table: CLIENTID DATE1 DATE2
for each CLIENTID can be more than one DATE1 so I have to select the MIN. Just doing this works fine:
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..


LLama Gratis a cualquier PC del Mundo.
Llamadas a fijos y móviles desde 1 céntimo por minuto.

[Non-text portions of this message have been removed]