Interested to Buy Any Domain ? << Click Here >> for more details...
how will I find the duplicate rows count from employees
tablein oracle.
- 2 Answers
- 5766 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
Can an extended stored procedure be called from inside a user-defined function?
What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?
What are the constraints on severity level in raiseerror?
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?
How can I detect whether a given connection is blocked?
How would you design a database for an online site, which would average a million hits a day?
Explain about normal forms?
What is a database development?
How to customize error conditions.
Explain about relational database management systems?
What is normalization? Explain different levels of normalization?
How long can an error message be in raiseerror function?
What are the 18 schemas?
Which four data types cannot be used as a return type from a user-defined function?
