2008/5/22 Renato <[EMAIL PROTECTED]>:
>
> SELECT DISTINCT
>  (SELECT
>     b.data_hora
>   FROM
>     Schema.Tabela b
>   WHERE
>     a.IP = b.IP
>   ORDER BY
>     b.data_hora
>   LIMIT 1)
> FROM
> Schema.Tabela a;

Não bastava o MIN (data_hora)?


-- 
skype:leandro.gfc.dutra?chat Yahoo!: ymsgr:sendIM?lgcdutra
+55 (11) 3040 7300 r155 gTalk: xmpp:[EMAIL PROTECTED]
+55 (11) 9406 7191 ICQ/AIM: aim:GoIM?screenname=61287803
+55 (11) 5685 2219 MSN: msnim:[EMAIL PROTECTED]
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral

Responder a