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
- 8726 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 lov dynamically at runtime & attach to text field?
Is it possible to split the print reviewer into more than one region ?
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
How to create an oracle testing table?
Can we save images in a database and if yes, how?
How to start an oracle instance?
6. Display the client name and order date for all orders using the traditional method.
How to select some rows from a table in oracle?
What is the relationship among database, tablespace and data file?
Is oracle the best database?
What is the order of defining local variables and sub procedures/functions?
What is the data pump import utility?
What is an oracle user role?
How to delete an existing row from a table in oracle?
what are archived logs?
