what is the querry to get first 10 records from the emp
table?(emp no is the primary key)
- 4 Answers
- 7264 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 are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?
I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5
as a technical developer in oracle applications which type errors feced in your experience sofar
What is Tax Categories?
default triggers available for reports
can u give guidance abt packages of plsql
What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f
What is the use of lockboxes? : oracle accounts receivable
Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable
what is semphore explian it?
Tell me about entire study of finacle software as soon as possible? give me the idea about questions which coulb be asked in interview of pnb it officers?
what is difference between inner join & nested query or subqueries
I need a Technical evaluation between Oracle and SAP ? please do a need ful.
What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable
