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
- 6599 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
What is recycle bin in Oracle?
What happens to indexes if you drop a table?
what's query optimization and without use of IN AND Exist can we get another way data from query
Explain database link?
What is oracle join syntax?
What is Undo Management Advisor in Oracle?
What is a subquery in oracle?
What is a cursor and what are the steps need to be taken?
Is oracle an operator?
State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.
Explain mutating triggers.
How many types of auditing in Oracle?
How to turn on or off recycle bin for the session?
In which language oracle has been developed?
Explain the use of rows option in imp command.
