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
