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

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

Question Posted / karthik

Answer Posted / karthik

select * from emp
where rownum <=10;

or

select * from (select rownum r,emp.* from emp)
where
r between 1 and 10;

Is This Answer Correct ?

8 Yes

0 No

Please Help Members By Posting Answers For Below Questions

can u pls share responsibilities for production how to environment in odi?and how to generate report ?

2409

IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?

2268

where the dff data will be stored

2451

I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5

2524

while creating requisitions i am unable to see the list of organisation can anyone help me out ?

2139

how can we add a field to the oracle standard forms through Form Persanlization or custom.pll

2406

What is auto invoicing? Explain : oracle accounts receivable

1129

as a technical developer in oracle applications which type errors feced in your experience sofar

2195

Explain how to close periods in ar. : oracle accounts receivable

1321

which gives Oracle R12 Financial training in delhi please give me answer its urgent?

2501

8. Supporting AP, AR and GL?

2315

What is the disk migration? what is the steps involved in oracle disk migration?

1226

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

4449

What is Tax Categories?

2116

please send me oracle pl/sql exp resume. and also faqs...

2500