select * from emp a where rowid = (select max(rowid) from emp where empno

how will I find the duplicate rows count from employees
tablein oracle.

Question Posted / avik ganguly

Answer Posted / avik ganguly

select * from emp a where rowid = (select max(rowid) from
emp where empno = a.empno group by empno having count(*) >1)

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How to use online Backups?

2211

How to generate OIDS

2267

How to customize error conditions.

2155

How long can an error message be in raiseerror function?

1011

What are the types of database model?

1105

Who are end users in dbms?

997

Explain about the hierarchical model of the database?

1124

In which database can extended stored procedures be added?

911

explain detail about ftp in datastage?

2252

How can I detect whether a given connection is blocked?

1062

State the acid rules?

1139

Explain about xml databases?

1084

What is data modeling with example?

1008

How to combine two function together?

2139

I have a few records all are same structures data, I want to store data in multiple targets how

2668