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
- 8540 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
Can we connect to ORACLE db using Windows Authentication?
while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511
In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col
Can we protect our pl/sql source code?
How to connect ms access to oracle servers?
Does facebook use oracle?
What is a view and how is it different from a table?
What are advantages of dateset in datastage?
How to use "if" statements on multiple conditions?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....
What is the difference between truncate & delete command?
What is materialized view in Oracle?
What are the different pseudo commands? Explain in general?
Why is oracle used?
