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
8713 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 do you store pictures in a database?

1002

What is difference between sid and service name in oracle?

954

How can I combine multiple rows into a comma-delimited list in oracle?

1058

ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process

2267

What is the difference between hot backup and cold backup in oracle?

1010

What are the limitations of check constraint?

1028

How to name query output columns in oracle?

1183

Please explain oracle data types with examples?

1067

What is an oracle and why it is used?

1147

what is the difference between data migration and production migration.

2344

Explain cascading triggers.

1073

In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??

1657

What are the different types of modules in oracle forms?

1001

Is java required for oracle client?

996

interview questions with answer for cts

2578