Try with this its working SELECT name,addres FROM ADDR WHERE name IN (SEL

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 / ajit

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

Answer Posted / ajit

Try with this its working
SELECT name,addres FROM ADDR WHERE name IN
(SELECT name FROM ADDR
GROUP BY name
HAVING COUNT(ADDRES) >1)

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How remove data files before opening a database?

1135

How to count groups returned with the group by clause in oracle?

1123

Explain alias?

1193

What is the usage of synonyms?

1219

What are the types of trigger in oracle?

1029

Explain the difference between sap and oracle?

1087

Can multiple cursors being opened at the same time?

1118

Is oracle a programming language?

1040

How can we delete duplicate rows in a table?

1040

How to enter a new row into a table interactively?

1053

What are the major difference between truncate and delete?

1137

What is an oracle cursor variable?

1133

Is there any function in oracle similar like group_concat of mysql?

1109

How to create a temporary table in oracle?

1335

What is analyze command used for?

1126