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
Answer Posted / vijayakumar
we need some sample data's ... then only we can able to write exact query....becoz here emp_id and address_id both are unique.. same data will not repeated....
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the major difference between truncate and delete?
How to create additional tablespaces for an new database?
What are the limitations of check constraint?
List out the difference between commit, rollback, and savepoint?
What is the difference between postgresql and oracle?
can u send the sql dumps to sivakumarr1987@gmail.com plz help me
How to assign a table row to a record variable?
How do we get field details of a table?
Can objects of the same schema reside in different tablespace?
what is reindexing?
Can we create trigger on materialized view in oracle?
Why should I use oracle database?
What is bind variable in oracle 11g?
why dont we assign not null constraint as table level constraint.
How to connect ms access to oracle servers?