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") -----Message d'origine----- De : pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx]De la part de Alex Envoyé : vendredi 15 avril 2005 13:59 À : pgsql-general@xxxxxxxxxxxxxx Objet : SQL Question Hi, i have a table ProdId | LastUpdate -------+------------ 100 | 2005-04-01 100 | 2005-03-01 100 | 2005-02-01 200 | 2005-04-01 200 | 2005-03-01 200 | 2005-02-01 - How can i select only the newest record for each ProdId ? 100 | 2005-04-01 200 | 2005-04-01 - How can i select to retrieve the last 2 dates in record 100 | 2005-04-01 | 2005-03-01 200 | 2005-04-01 | 2005-03-01 Thanks Alex ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org This mail has originated outside your organization, either from an external partner or the Global Internet. Keep this in mind if you answer this message. This e-mail is intended only for the above addressee. It may contain privileged information. If you are not the addressee you must not copy, distribute, disclose or use any of the information in it. If you have received it in error please delete it and immediately notify the sender. Security Notice: all e-mail, sent to or from this address, may be accessed by someone other than the recipient, for system management and security reasons. This access is controlled under Regulation of Investigatory Powers Act 2000, Lawful Business Practises. ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
