|
-
I am trying to clean up this table (bill_info).
fpn job_no description
--- -------- --------------
X01 Z001 DUDE
X01 Z001 DUDE/
X02 Z002 HI
X02 Z002 HI,
X03 Z003 WORLD
X04 Z004 GOD
How can I show all the uplicate record so I can do the
clean up. I've tried to use this
select fpn, job_no, description
from bill_info
group by fpn, job_no,description
having count(*) > 1;
but it only returns one record which are duplicate ones.
I need to see all the records wich are duplicate so I can choose which one I want to delete
Thanks,
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|