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
8446 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 create a new tablespace in oracle?

932

What is an oracle and why it is used?

1077

What is the exact use of Collections?

2094

How to create a table interactively?

996

How to assign data of the deleted row to variables?

1013

what is reindexing?

1609

How to rename a tablespace in oracle?

1033

What is Reduced List of Values?

2101

What is the data pump export utility?

1021

How to build data dictionary view an new database?

958

HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

2188

How to get last row id?

938

What is sharded cluster?

924

What are the system predefined user roles?

982

22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100

1953