what is the querry to get first 10 records from the emp
table?(emp no is the primary key)
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 |
Post New Answer View All Answers
Are These Dff's Flexible?
A scenario for amount correction & how to use amount correction functionality in AP invoices
what are the API of GL,PO,AP
What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable
Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha
What is Tax Categories?
What is the difference between recovery and restoring of the oracle database?
What are different types of receipt reversals ? Explain them : oracle accounts receivable
what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable
What is mrc and what is its use? : oracle accounts receivable
what are basic modules required to implement oracle application in any oraganisation?
Explain the process of recievables in oracle financials. : oracle accounts receivable
What is Restricted Mode of Instance Startup in Oracle?
What view would you use to determine free space in a tablespace?
Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable