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 is a snapshot log?
How to call a sub procedure?
Explain what are the uses of rollback segment?
What is the recommended interval at which to run statspack snapshots, and why?
There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??
How to define default values for formal parameters?
What is open database communication (odbc) in oracle?
material view and view disadvantages?
Can we write insert statement in function in oracle?
How to bring a tablespace online?
How to assign query results to variables?
What is an oracle?
How to call a stored function in oracle?
Can you drop an index associated with a unique or primary key constraint?
How data locks are respected in oracle?