advanced code snippet search

Posted By

geekzspot on 12/05/12


Tagged


Versions (?)

Oracle Find Duplicates

 / Published in: SQL
 

Here's a quick and simple SQL to detect duplicate data or rows (Here we use two columns: empno and ename)

Expand | Embed | Plain Text 
  1. SELECT empno,ename FROM emp GROUP BY empno,ename
  2. HAVING count(*) > 1;

Report this snippet  

You need to login to post a comment.