select Emp_ID from table_name groupe by Emp_ID having count(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 / shashi

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

Answer Posted / shashi

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

Is This Answer Correct ?

3 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

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

990

How to convert characters to numbers in oracle?

998

What is a sub query and what are the different types of subqueries?

1072

How to list all tables in your schema?

989

How to synchronize 2 schema's objects?

2114

Is rowid unique in oracle?

938

while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

4292

Is a rollback possible to any savepoint?

997

What do you mean by merge in oracle?

937

What is oracle database 10g express edition?

1070

What is save point in oracle database?

1239

Is postgres faster than oracle?

969

What suggestions do you have to reduce the network traffic?

899

what is the dual table in oracle?

932

How to create a new view in oracle?

1013