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
- 8550 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
how to make an oracle object
What are the differences between lov and list item?
How a tablespace is related to data files?
Can we create database in oracle using command line ?
What are the oracle differences between nvl and coalesce
Can group functions be used in the order by clause in oracle?
How to establish administrator authentication to the server?
What do you know about normalization? Explain in detail?
IS it possible to built the oracle database without setting the kernal parameters?
how to convert .db (extention) database file into .dmp (extention ) for oracle database ?
How can I create database in oracle?
What do you mean by a deadlock?
ABOUT IDENTITY?
what is meant by magic query
Explain what does a control file contain?
