Re: SQL Question

GIROIRE, Nicolas (COFRAMI) wrote:
> For the first request (How can i select only the newest record for each ProdId ?), you can do :
>
> select * from test."tableProd" u
>     where u."LastUpdate" = (select max(t."LastUpdate")
>                     from test."tableProd" t
>                     where u."ProdId" = t."ProdId")

Although this only guarantees one row if LastUpdate is unique for every
ProdId.
--
   Richard Huxton
   Archonet Ltd