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
- 6686 Views
- IBM, I also Faced
- E-Mail Answers
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
Give syntax for SQL and ORACLE joins.
What is connection pool in oracle?
What privilege is needed for a user to delete rows from tables in another schema?
How many types of table in Oracle?
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?
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 the scope of a local variable?
How to select an oracle system id (sid)?
How to retrieve the count of updated rows?
How do I know if oracle is installed on windows?
How can Oracle users be audited?
How can I combine multiple rows into a comma-delimited list in oracle?
In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.
How to convert a date to char in oracle? Give one example.
What is the purpose of save points in oracle database?
