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
4026 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

Define b-trees.

0 Answers

What is the 3-tier architecture?

0 Answers

1)what is the difference between view and materilized view? 2)what is the difference between delete and truncate? 3)what is the difference between migration and upgration? 4)what is the difference between RMAN HOT BACKUP and normal hot backup?

2 Answers 3i Infotech,

What is the mechanism provided by ORACLE for table replication ?

1 Answers

PL/SQL supports which datatypes?

2 Answers

Where is database data stored?

0 Answers

What are cursors give different types of cursors?

0 Answers

What are the Common SQL Functions Used for Data Aggregation?

1 Answers

What are different type of normalization?