Received: from yoda.isnet.com.br (IDENT:root@[200.215.24.162]) by hub.org (8.9.3/8.9.3) with ESMTP id KAA39391 for ; Thu, 19 Aug 1999 10:29:24 -0400 (EDT) (envelope-from righetto@isnet.com.br) Received: from han ([192.168.36.2]) by yoda.isnet.com.br (8.9.3/8.8.5) with SMTP id MAA06917 for ; Thu, 19 Aug 1999 12:48:56 -0300 Message-ID: <00a701beea4f$6b443260$0224a8c0@isnet.com.br> From: "Carlos Henrique Righetto Moreira" To: Subject: selecting newer rows Date: Thu, 19 Aug 1999 11:30:41 -0300 MIME-Version: 1.0 Content-Type: text/plain; charset="x-user-defined" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2314.1300 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300 Hi. Thats my problem: I have a table with some fields and a thousand of rows. By a mistake in the past someone entered duplicated information (the key field is different). I need to select some rows from this table but I just want only the newer row from the table in the case that row is duplicated. I made myself clear? Anyone can help me? -carlos