Posts Oracle check for duplicates
Post
Cancel

Oracle check for duplicates

1
2
3
4
5
6
--http://stackoverflow.com/a/59242
select invoice_no, count(invoice_no)
from THE_OWNER.MY_TABLE
where invoice_no between 6544353 and 9876533
group by invoice_no, line_num
having count (invoice_no) > 1

origin - http://www.pipiscrew.com/?p=6330 oracle-check-for-duplicates

This post is licensed under CC BY 4.0 by the author.
Contents

Trending Tags