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
8710 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 a trace file and how is it created in oracle?

1055

Hi Can any one tell me what are the API's used in requisition import.

1920

Explain user account with reference to oracle.

982

How to bring a tablespace offline?

1059

What privilege is needed for a user to delete rows from tables in another schema?

1066

Calculate difference between 2 date / times in oracle sql?

1040

Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

2355

What is PL/SQL ?

2053

In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

2284

Can we save images in a database and if yes, how?

1063

How many types of tables are there in oracle?

1061

Can group functions be mixed with non-group selection fields?

1020

Does facebook use oracle?

1031

How to end the current transaction in oracle?

1028

How many categories of data types?

993