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
How do you tell what your machine name is and what is its IP address?
What are the oracle differences between nvl and coalesce
What is the database name in oracle?
How to resolve the ORA-39133 error in Oracle?
master table and child table performances and comparisons in Oracle ?
How to delete a column in an existing table?
What is oracle datasource?
What is bind variable in oracle 11g?
Explain the importance of .pll extension in oracle?
Can objects of the same schema reside in different tablespace?
How to start a new transaction in oracle?
What is the difference between primary key and unique key and foreign key in oracle?
How to enter a new row into a table interactively?
How to assign query results to variables?
How many types of tables are there in oracle?