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

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

Question Posted / suresh

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

Answers were Sorted based on User's Feedback

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

Answer / lara

SELECT column FROM table
WHERE ROWNUM <= 10

Is This Answer Correct ?

21 Yes

2 No

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

Answer / 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

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

Answer / 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

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

Answer / prachi

select TOP(10) from emp
orderby empid

Is This Answer Correct ?

1 Yes

8 No

Post New Answer

More Oracle AllOther Interview Questions

how can we send a concurrent program output to the clients through mail or fax give me example.

1 Answers Cap Gemini,

what ASIS BUSINESS PROCESS IN ORACLE FINANCE

0 Answers

Olap tools

0 Answers

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

0 Answers HCL,

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.

0 Answers Wipro,

What are the main diff. between oracle 7.3 and oracle 8i?

1 Answers

What is auto invoicing? : oracle accounts receivable

0 Answers

Can we get the deleted Record again if the delete transaction has been committed.

4 Answers

How to find locks exists in a table or not?

1 Answers HCL,

Name a tablespace automatically created when you create a database.

3 Answers HCL,

You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?

1 Answers

HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..

0 Answers Infosys,

For more Oracle AllOther Interview Questions Click Here