Finding duplicate rows in a table
3> select cargo_id, dest_id
4> from routing t1
5> where
6> ( select count(*)
7> from routing t2
8> where t2.dest_id = t1.dest_id ) > 1
9>
10> go
Test urself - Latest IT Sample Papers
Scroll down to see all archieves.
click here to view HOT IT JOBS
3> select cargo_id, dest_id
All JAVA Savvy ….