Duplicate rows quaetion

[abhaysk]

I think u can avoid OR clause.

select
   *
from
   lot
where
   (issueid,quantity) in
      (
      select
         issueid,
         quantity
      from
         lot
      where
         trunc(createdate) in 
          (TO_DATE('06/16/2003','MM/DD/YYYY'),TO_DATE('06/17/2003','MM/DD/YYYY'))
      group by
         issueid,
         quantity
      having
         count(1) > 1
       )