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
- 6596 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / abc
select emp_id from table_name a where a.rowid < (select MAX
(rowid) from test b where b.address_id=a.address_id)
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How to create a table interactively?
How to get maxsal , minsal, ename department wise in single query
Explain oracle insert into command?
Explain a synonym?
How do I manually uninstall oracle client?
How many types of synonyms in Oracle?
I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.
What is a dead lock in oracle?
Explain an exception and its types?
Is there any function in oracle similar like group_concat of mysql?
How can we view last record added to a table?
How to pass parameters to procedures in oracle?
What is the difference between postgresql and oracle?
How can I convert single byte kana characters into multi byte kana characters and vice-versa.
What are the set operators union, union all, minus & intersect meant to do?
