select * from emp where rownum<=10; or select * from (select rowid

what is the querry to get first 10 records from the emp
table?(emp no is the primary key)

Question Posted / sunil

Answer Posted / sunil

select * from emp where rownum<=10;

or

select * from (select rowid ri,e.* from emp e order by ri)
where ri<=10;

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the difference between conversions and interfaces? : oracle accounts receivable

1231

WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?

2955

Explain the use of table functions.

2485

types of receipts and detail desription about recipts and tables effected by receipts?

2075

Explain prerequisites and post activities of oracle database installation

2132

default triggers available for reports

2211

What is an Oracle database Full Backup?

1131

which one is currently in used software cmpanies.

2153

HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?

2061

1. What is PO rate variance gain and loss?

2920

What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f

4446

Can you explain how to adjust the amount of advance already received against an invoice? : oracle accounts receivable

1276

Explain about party and customer in ar : oracle accounts receivable

1209

WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?

2113

Difference between transaction type and transaction sources. : oracle accounts receivable

1032