select Emp_ID from table_name group by 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 / nithya

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

Answer Posted / nithya

select Emp_ID from table_name group by Address_ID
having count(Address_ID )>1;

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is pragma autonomous transaction in oracle?

1125

When do we use group by clause in a sql query?

1101

What happens if you lost a data file?

1083

What is oracle update statement with inner join ?

1117

How to convert character types to numeric types?

1193

What is an oracle database?

1111

What is the relation of a user account and a schema?

1176

What are operators in oracle?

1103

What is an oracle function?

1244

How can we find out the duplicate values in an oracle table?

1122

Explain what are the type of synonyms?

1188

query optmization techniques and quwry analyser+projects+ppts

2469

What is Trigger in Oracle?

1244

Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables

2119

How to create a table index?

1231