Interested to Buy Any Domain ? << Click Here >> for more details...
i have a table with the columns below as
Emp_ID Address_ID Address_Line City Country
-------- --------- ----------- ------ ---------
Q: Display the Emp_ID's those having more than one
Address_ID
- 7 Answers
- 8715 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / ajit
Try with this its working
SELECT name,addres FROM ADDR WHERE name IN
(SELECT name FROM ADDR
GROUP BY name
HAVING COUNT(ADDRES) >1)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain the use of file option in exp command.
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.
Is postgres faster than oracle?
What is a trigger and what are its types in oracle?
What is a trace file and how is it created in oracle?
What is blob datatype?
How to define a procedure inside another procedure?
What is private procedure oracle?
Explain the use of online redo log files in oracle.
Differentiate between translate and replace?
How to speed up webrick?
What is the difference between pre-select and pre-query?
Explain about your project and its relation to the current job position you are applying to?
What is key preserved table?
20. Using a set operator, display the client number of all clients who have never placed an order.
