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

How to define an anonymous block?

1158

What are the data types in oracle?

1040

What is an oracle user account?

993

Is oracle an operator?

924

What is oracle host variable?

1066

How to find out what oracle odbc drivers are installed?

1042

What is the exact use of Collections?

2143

Please explain oracle data types with examples?

1074

Can you have more than one content canvas view attached with a window ?

2333

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

1929

What is a procedure in oracle?

1199

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

1058

How to delete an existing row from a table in oracle?

1072

What is a lookup table in oracle?

973

Explain the features of oracle?

1046