simply write the sql query like sql>select Emp_ID from table

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 / gyana ranjan behera

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

Answer Posted / gyana ranjan behera

simply write the sql query like

sql>select Emp_ID from table_name groupe by Address_ID
having count(Address_ID )>1;
this is working as per the requirement..i tested
that..thanx ..pls send responces and questions on my mail
id to discuss new situations.

Is This Answer Correct ?

14 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What do you understand by a database object?

985

What is the simplest tool to run commands on oracle servers?

954

What is an oracle tablespace?

981

What is tns name?

927

What is the difference between substr & instr functions?

1118

What are the oracle differences between nvl and coalesce

1064

What is an oracle table?

929

What is the difference between PFILE and SPFILE in Oracle?

993

What is a database table in oracle?

950

What are named parameters?

1027

Is a rollback possible to any savepoint?

997

What are the differences between number and binary_float in oracle?

1050

What is truncate oracle?

914

Is it possible to set second Primary Key Constraint in a table in Oracle Database ?

1055

Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

2297