selecting newer rows

From: "Carlos Henrique Righetto Moreira" <righetto(at)isnet(dot)com(dot)br>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: selecting newer rows
Date: 1999-08-19 14:30:41
Message-ID: 00a701beea4f$6b443260$0224a8c0@isnet.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Jon Windfeld Bundesen 1999-08-19 15:42:05 What JDBC datatype can be used for DATETIME ?
Previous Message KOUL Christian 1999-08-19 14:01:26 (pas d'objet)