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
- 7828 Views
- Zensar, I also Faced
- E-Mail Answers
Answer Posted / sudipta santra
select * from A group by no having count(*)>1 ;
| Is This Answer Correct ? | 7 Yes | 3 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 to view the data files in the current database?
Why do you create or replace procedures rather that drop and recreate.
Difference between varchar and varchar2 data types?
How would you begin to troubleshoot an ORA-3113 error?
Point the difference between translate and replace?
What is a tns service name?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
How to write a query with an inner join in oracle?
What is the use of file param in imp command?
How to define a variable of a specific record type?
How can we force the database to use the user specified rollback segment?
How to run create database statement?
What are nested tables?
How to rename an existing table?
