Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 8714 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
How to invoke the original export import utilities?
What is a server parameter file in oracle?
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
What is oracle database client?
How to test null values?
How to find the duplicate rows count from employees table in oracle?
Explain what does a control file contain?
what is the scenario where you take the database to NoArchivelog mode?
How to convert characters to times in oracle?
what happened to the global index when I truncate the data in one of the partition?
What is a data dictionary and how can it be created?
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
How to speed up webrick?
How to get a create statement for an existing table?
What are named parameters?
