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
8716 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 to fetch the row which has the max value for a column?

1000

Can we call procedure inside function in oracle?

1084

How can Oracle users be audited?

1109

Explain oracle instance.

1171

Explain an integrity constrains?

1146

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

2344

How much memory your 10g xe server is using?

1103

when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.

1994

How will you identify oracle database software release?

1008

What are the oracle differences between nvl and coalesce

1147

What is define in oracle?

1060

What is different types of joins?

1018

How to retrieve values from data fields in record variables?

1112

How data locks are respected in oracle?

1069

How to set up autotrace for a user account?

1059