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
Answer Posted / nitin
SELECT EMP_ID FROM EMP_ADDRESS WHERE ADDRESS_ID IN
(SELECT ADDRESS_ID FROM EMP_ADDRESS
GROUP BY ADDRESS_ID
HAVING COUNT(ADDRESS_ID) >1)
Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
What do you mean by merge in oracle?
What is blob data type in oracle?
What is a subquery?
What are the benefits of ordbms?
Give the advantages and disadvantages of clusters.
what are bitmap indexes? How does they work?
What is flashback in Oracle?
How to invoke the data pump import utility?
What happens to the current transaction if the session is killed?
How to do a full database export?
Please explain joins in oracle?
What is an anonymous block?
What is transport network substrate (tns) in oracle?
Please explain drop constraint oracle?
Is oracle the best database?