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
4071 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 most used database?

0 Answers

If an UNIQUE KEY constraint on DATE column is created, will it accept duplicate values?

2 Answers

What is a database in layman terms?

0 Answers

What is sql in dbms?

0 Answers

What is database management system(dbms) and why it is used?

0 Answers

Where is the database stored?

0 Answers

What is difference between database and website?

0 Answers

What is the use of FILE option in EXP command ?

1 Answers

Does netlib support windows 95?

0 Answers

What is rdbms architecture?

0 Answers

how Data is stored in a file so that Direct Searching can be performed

0 Answers HCL,

What are different cursor types in dbms?

0 Answers

For more Database Management Interview Questions Click Here