select emp_id from table_name a where a.rowid

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

Question Posted / abc

7 Answers
8943 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

Please Help Members By Posting Answers For Below Questions

What is object data modeling?

1017

How can we view last record added to a table?

1108

State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.

1096

How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

2314

What happens in oracle commit?

1081

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

2374

How to divide query output into groups in oracle?

1034

When system tablespace is created?

1093

How can we force the database to use the user specified rollback segment?

1201

How to add another datafile to a tablespace?

1092

What is the data pump export utility?

1134

Is insert autocommit in oracle?

1134

How to drop an index in oracle?

1121

How to experiment a data lock in oracle?

1113

ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process

2345