how will I find the duplicate rows count from employees
tablein oracle.
Answer Posted / manoj
select employee_id, count(*) from employees group by
employee_id having count(*) > 1
| Is This Answer Correct ? | 18 Yes | 0 No |
Post New Answer View All Answers
How long can an error message be in raiseerror function?
What are the three types of database design?
On friday, you issued several insert statements using query analyzer. You then verified the data had been correctly entered with a select statement on monday, your users report that the data is not there what happened?
How to replace not in with not exist?
Who are end users in dbms?
Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on
Where is dbms used?
Explain about a primary key?
State the acid rules?
Explain the process of the user request and data generating?
Which four data types cannot be used as a return type from a user-defined function?
How to customize error conditions.
How you can make a parameterized view?
What are the types of database model?
How to combine two function together?