how will I find the duplicate rows count from employees
tablein oracle.
- 2 Answers
- 5043 Views
- I also Faced
- E-Mail Answers
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 |
Post New Answer View All Answers
What are the main phases of database development?
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?
What is a database development?
Why does this query return 0?
Who are end users in dbms?
You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?
State the acid rules?
Explain the role of indexing in databases?
How is data stored in dbms?
fact table and dimension table containg one to many relationship or many to one relastionship
How can I detect whether a given connection is blocked?
How to replace not in with not exist?
What is dbms and its application?
What is database design and development?
What is DB Development software?
