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

How do I limit the number of rows returned by an oracle query after ordering?

1172

Name the various constraints used in oracle?

1023

Explain rename?

988

How does one get the view definition of fixed views/tables?

1023

How to select all columns of all rows from a table in oracle?

1055

What is SQL access advisor in Oracle?

1196

What is query image?

985

How to use "for" statements in oracle?

1076

What are the numeric comparison operations?

1121

Why is oracle used?

945

What is the Tune Query

2298

How to assign data of the deleted row to variables?

1077

What is the simplest tool to run commands on oracle servers?

1013

Explain database link?

1131

What is MTTR advisor in Oracle?

1090