i need query for displaying the eno,ename in a table from row 2 to row 5

i need query for displaying the eno,ename in a table from row
2 to row 5

Question Posted / guest

1 Answers
4108 Views
I also Faced
E-Mail Answers

i need query for displaying the eno,ename in a table from row 2 to row 5..

ans 1 -

select *
from (
select rownum num , empno, ename
from emp
)
where num between 2 and 5

------------------

we can also use row_number function

Is This Answer Correct ?

8 Yes

2 No

Post New Answer

More Database Management Interview Questions

Mention the different types of cursor?

0 Answers

Explain vdl (view definition language)?

0 Answers

Can two oracle blocks have the same address?

0 Answers

Describe the difference between homogeneous and heterogeneous distributed database.

0 Answers

Where the Databases overall structure is maintained ?

1 Answers

What are foreign keys in database?

0 Answers

What are the main components of a database system?

0 Answers

Define entity, entity type, and entity set.

0 Answers

What will be the maximum size of an extent of a segment if the tablepac's default storage values are specified as (initial 8K next 16k minextent 4 pctincrease 100).Explain.

0 Answers

List few restrictions that are imposed while creating views?

0 Answers

How view is related to data independence?

0 Answers

How to select the first record in a given set of rows?

0 Answers

For more Database Management Interview Questions Click Here