Originally posted by marist89
Originally posted by ronnie
Nope there is no primary key.
How do you know you have duplicates, then?

select account_id, trade_date, settlement_date, amount, quantity
from trades
group by account_id, trade_date, settlement_date, amount, quantity
having count(*) > 1