Hi, I have a table and I want to identify duplicate rows of account numbers and sequence numbers. The closest I can think of is below and doesn't work. Select ACCOUNT_NO,SQN_NO from ACCOUNT_TABLE WHERE (ACCOUNT_NO,SQN_NO) NOT IN (select distinct ACCOUNT_NO,SQN_NO from ACCOUNT_TABLE)
As always, any help is appreciated.
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.