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
8458 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

material view and view disadvantages?

1019

How do I uninstall oracle 11g?

1043

What are the uses of synonyms?

1084

I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance

2256

What are the data types in oracle?

981

Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?

1047

How to estimate disk space needed for an export job?

992

What is clustered table in Oracle?

1108

How to define an oracle sub procedure?

1058

Can the query output be sorted by multiple columns in oracle?

936

What is the recommended interval at which to run statspack snapshots, and why?

2861

What is a snapshot in oracle database?

974

Oracle

2321

why should i declare foreign key constraint as self relation instead of binary relation in tables ?

1986

how do u setup a replication site?

1925