Select Statement help... 1

[mistrymk]

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.

 

[al1024]

If you want select duplicate rows on (ACCOUNT_NO, SQN_NO), you could use this request :

select  *
from    ACCOUNT_TABLE
where   (ACCOUNT_NO, SQN_NO) in           
        (   select  ACCOUNT_NO
                ,   SQN_NO
            from    ACCOUNT_TABLE
            group by ACCOUNT_NO
                ,   SQN_NO
            having  count(*) > 1
        )
;

 

[mistrymk]

Thank-you al1024, thta's done the trick.