GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Oracle  >  Oracle Forms 4.0
Go To First  |  Previous Question  |  Next Question 
 Oracle Forms 4.0  |  Question 64 of 92    Print  
how to find out duplicate records ?

  
Total Answers and Comments: 4 Last Update: November 19, 2007     Asked by: ravis 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
October 12, 2005 08:59:38   #1  
saket kumar singh        

RE: how to find out duplicate records ?
using rowid
 
Is this answer useful? Yes | No
June 23, 2006 05:56:12   #2  
Atanu Basu        

RE: how to find out duplicate records ?

LET THINK EMP IS A TABLE AND EMP_CODE IS THE KEY ATTRIBUTE

SELECT * FROM EMP WHERE ROWID NOT IN

(SELECT MIN(ROWID) FROM EMP GROUP BY EMP_CODE)


 
Is this answer useful? Yes | No
December 04, 2006 07:13:20   #3  
venkat balabadruni        

RE: how to find out duplicate records ?
select * from emp where rowid not in ( select min(rowid) from emp group by ename);
 
Is this answer useful? Yes | No
November 18, 2007 01:36:45   #4  
vara        

RE: how to find out duplicate records ?
select * from emp a where rowid >(select min(rowid) from emp b where a.empno b.empno)
 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape