|
-
Duplicate rows question
I'm trying to get all duplicates from a table.
there are two columns that are the same, issueid and quantity.
When I run the following, I only get one of the duplicate rows, not all of them....
select issueid,quantity
from lot
where trunc(createdate)=TO_DATE('06/16/2003','MM/DD/YYYY') or
trunc(createdate)=TO_DATE('06/17/2003','MM/DD/YYYY')
group by issueid,quantity
having count(*) > 1
Any ideas how to retrieve all the duplicate rows?
thanks
Last edited by rgaskell; 06-24-2003 at 05:57 AM.
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
|