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

What are the differences between blob and clob in oracle?

1136

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2173

What are group functions in oracle?

1097

What is a server parameter file in oracle?

1098

what is normalisation?what are its uses?

2334

How to drop an index?

1015

Name the three major set of files on disk that compose a database in Oracle?

1171

How to store only time; not date and time?

1070

How to use subqueries in the from clause in oracle?

1165

What is Reduced List of Values?

2245

How to convert numbers to characters in oracle?

1080

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1924

How do I connect to oracle?

1080

What is query image?

1023

How data locks are respected in oracle?

1113