SELECT EMP_ID FROM EMP_ADDRESS WHERE ADDRESS_ID IN (SELECT ADDRESS

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

Question Posted / nitin

7 Answers
8753 Views
IBM, I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

How to define an oracle cursor variable?

1040

How to view all columns in an existing table?

946

What is truncate oracle?

981

Differentiate between function and procedure in oracle.

1091

11. Display the client number and name and the client number and name of the person who referred that client.

2347

What is an oracle recycle bin?

1016

What are the advantages of oracle?

1034

WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

2214

How to define and use table alias names in oracle?

952

What happens to the current transaction if the session is ended?

1105

What are the different types of synonyms?

1147

How to use "for" statements in oracle?

1083

What is the relationship among database, tablespace and data file?

998

what happened to the global index when I truncate the data in one of the partition?

2029

What is an oracle data file?

1119