I have table-A(1,2,3,4,4,5,6,6,6,7).
how to get all duplicate values?what is sql query?
- 5 Answers
- 7775 Views
- Zensar, I also Faced
- E-Mail Answers
Answer Posted / sam
SELECT num,
COUNT(num) AS NumOccurrences
FROM A
GROUP BY num
HAVING ( COUNT(num) > 1 )
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Will you be able to store pictures in the database?explain.
What is a proxy object?
What is a package in oracle?
How to add a new column to an existing table in oracle?
What happens if you use a wrong connect identifier?
When do you get a .pll extension in oracle? Explain its importance
What is raw datatype in oracle?
How to export your own schema?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
How do I limit the number of oracle database connections generated by weblogic server?
What are the types of trigger in oracle?
What are the execution control statements?
What are advantages of dateset in datastage?
what is reindexing?
What is recovery manager in Oracle?
