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
- 7 Answers
- 6598 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
Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
What language does oracle use?
How to drop an index?
What do you mean by a tablespace?
Can we connect to ORACLE db using Windows Authentication?
How to compare dates in oracle sql?
How to use subqueries in the from clause in oracle?
what is normalisation?what are its uses?
How to declare a local variable?
why dont we assign not null constraint as table level constraint.
In what script is snap$ created? In what script is the scott/tiger schema created?
What is the usage of synonyms?
what is dynamic SGA and static SGA
How will you differentiate between varchar & varchar2?
