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

What are the three basic rules which are to be followed for the relational model of the database?

1074

Explain about the hierarchical model of the database?

1174

fact table and dimension table containg one to many relationship or many to one relastionship

2558

How long can an error message be in raiseerror function?

1049

What are the three types of database design?

1090

Explain about xml databases?

1126

What are the key features of dbms?

1049

How to replace not in with not exist?

2190

Explain about query and reporting.

2144

State the acid rules?

1188

Write the fastest query to find out how many rows exist in a table?

1176

Explain about normal forms?

1113

What are the types of database model?

1143

Explain about post-relational databases?

1088

Pgm A calls Pgm B and pgm B uses cursor, when pgm B is called second time, the program is abending saying the cursor is opened? Why?

2476