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

what is the difference between inline query and corelated subquery

1 Answers

What are fact tables and dimension tables ? What is dimensional modeling and star schema design

0 Answers

What is big data database?

0 Answers

What does fill factor concept mean with respect to indexes?

0 Answers

What is the best way to determine whether firebird server is running?

0 Answers

What is an example of a database?

0 Answers

How to detect applications and users that hold transactions open too long?

0 Answers

Explain ddl interpreter?

0 Answers

What are the ways to tune reporting services?

0 Answers

How does a database partition work?

0 Answers

What is system catalog or catalog relation?

0 Answers

What versions of clipper does netlib support?

0 Answers

For more Database Management Interview Questions Click Here