SELECT DISTINCT * FROM ACCOUNTS gives me the non dup records from my accounts table. How do I get the dups using the same command? Is there something like SELECT NOT DISTINCT * FROM ACCOUNTS?

Any suggestions or comments will be welcome, thank you.