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

4 Answers
8287 Views
Verizon, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE

2283

default triggers available for reports

2271

we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.

2592

How would you determine what sessions are connected and what resources they are waiting for?

2179

Difference between negative and positive adjustments : oracle accounts receivable

1162

Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable

1193

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

1269

My requirement is like in database some defects are present and i need to clean them.To be brief for example every employee should have active assigments.So for those records which are not having status as active or null ,i need to update the roecords using API with the correct value. Client will provide a flat file for the records whch are defected.So i need to run the API for those records (flat file)and update the data in database. So my question is how to handle this requirement.Is there any existing API for this purpose?If yes then please send me the NAME. How to update the records in the database using flatfile. Any pointer will be appreciated.Thanks in advance.

2266

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

1330

how to write customizations in po

1660

WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?

2068

What is mrc and what is its use? : oracle accounts receivable

1306

what are the tools used for oracle 10g in real time.

2493

How do you create a credit note against an invoice? : oracle accounts receivable

1144

what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable

1172