how will I find the duplicate rows count from employees
tablein oracle.
Answers were Sorted based on User's Feedback
Answer / 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 |
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?
Explain what a database is?
How to customize error conditions.
What are the constraints on severity level in raiseerror?
How can you log an error to the server event log from a stored procedure?
What is the system function to get the current user's user id?
Can an extended stored procedure be called from inside a user-defined function?
Explain the process of the user request and data generating?
Explain about a primary key?
How to use online Backups?
Define candidate key, alternate key, composite key?
30 Answers IAS, IBM,
What are defaults? Is there a column to which a default can't be bound?