what is the querry to get first 10 records from the emp
table?(emp no is the primary key)
- 4 Answers
- 6633 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
What is auto invoicing? : oracle accounts receivable
What is the importance of batch source set up in ar? : oracle accounts receivable
What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
What is mrc and what is its use? : oracle accounts receivable
Is there any link between pr form(purchse requisition)and po form(purchase order)
1. What is PO rate variance gain and loss?
what is semphore explian it?
I need a Technical evaluation between Oracle and SAP ? please do a need ful.
Why more redos are generated when the oracle database is in begin backup mode?
as a technical developer in oracle applications which type errors feced in your experience sofar
Explain prerequisites and post activities of oracle database installation
what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable
What is db_recovery_file_dest in oracle? When do you need to set this value?
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.
