Leroy,

Table should has index on Detail_no. Then you can use:
sele detail_no from... group by 1 having cnt(*) =1

Best Wishes


>>>>>>>>>>>>>>>>>...your message below

Hello Everyone!!!
I have a table has a field that is called Detail_no.
In this table I have some detail_no's that have duplicates and that is fine because one stands for a shipped record and the other stands for a recieved record.

However, I need the detail_no's that do not have a duplicate.
(shipped but Not received or Received but not shipped )... I know that does not make sense but it happens.
I am trying to find the best or Fastest way to do this because I a dealing with a table that starts out with over 400,000 records and eventually comes down to maybe 600.
I don't know if there is a function to do this or not. But any help would be greatly appreciated.

Thanks in advance