using the values held in columns

[Vann]

hello,
i'm writing a query that will omit all records which are up to date. each record has recordnumber as its key, but because the dates are not unique, it dislays records which are not up to date as well.
how can i omit all records with the same record number?

 

[angiole]

Could you please clarify your question further.

 

[PruSQLer]

Yes, it's a bit difficult figuring out exactly what you want but if your last sentence says it all, the following would work I think.

select *
From Table1
Where record_num in
(Select record_num
From Table1
Group by record_num
having count(*) < 2 )