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
- 8729 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
Explain the use of rows option in imp command.
How to do paging with oracle?
What is the difference between sharding and partitioning?
Explain about your project and its relation to the current job position you are applying to?
What is the usage of merge statement?
Explain the use of ignore option in imp command.
WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?
is there a tool to trace queries, like profiler for sql server?
How to specify default values in insert statement using oracle?
In the oracle version 9.3.0.5.0, what does each number shows?
What are the differences between char and nchar in oracle?
State and explain about oracle instance?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
How to get a list of all background sessions in the database?
Can a formula column referred to columns in higher group ?
