Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 8590 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
I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.
How do we get field details of a table?
What is a read only transaction in oracle?
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
How to use subqueries with the in operator using oracle?
What happens if you lost a data file?
What is oracle datasource?
How to retrieve data from an cursor to a record?
How to filter out duplications in the returning rows using oracle?
Explain self joins in oracle?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
How to use "in out" parameter properly?
What is an index associated with a constraint?
How to define default values for formal parameters?
How to convert a string to a date in oracle database?
