simply write the sql query like sql>select Emp_ID from table

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 / gyana ranjan behera

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

Answer Posted / gyana ranjan behera

simply write the sql query like

sql>select Emp_ID from table_name groupe by Address_ID
having count(Address_ID )>1;
this is working as per the requirement..i tested
that..thanx ..pls send responces and questions on my mail
id to discuss new situations.

Is This Answer Correct ?

14 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the roles of dba?

1137

what are the default admin accounts in Oracle 10g ?

1024

how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?

2415

What is raw datatype?

1190

What is a snapshot in oracle database?

1073

Will you be able to store pictures in the database?

1177

What is the quickest way to fetch the data from a table?

1101

What are the differences between number and binary_float in oracle?

1150

What do you mean by a deadlock?

1110

What is ordinary table in oracle?

1243

How to list all tables in your schema?

1120

What is Data Dictionary Cache in Oracle?

1244

How to drop an index in oracle?

1121

How do we create privileges in oracle?

1103

how do u setup a replication site?

2033