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
4114 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 truncate and delete commands?

0 Answers

Why do we need foreign key?

0 Answers

What do you mean by Correlated subquery in database?

0 Answers B-Ways TecnoSoft,

What are records and fields in a database?

0 Answers

Briefly describe the three types of sql commands.

0 Answers

What is 1nf in database?

0 Answers

What is an optimization and performance tuning and how does it really work in practical projects?

0 Answers

What are the main components of a database system?

0 Answers

What is oracle block?

0 Answers

What's the difference between clustered and non-clustered indexes?

0 Answers

What are the different levels of abstraction in the dbms?

0 Answers

What are the examples of database?

0 Answers

For more Database Management Interview Questions Click Here