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
4196 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 are the Different Types of Joins and How do They Work?

1 Answers

What is sql in dbms?

0 Answers

What is primary key in database?

0 Answers

How do you backup a database?

0 Answers

What do you mean by index hunting?

0 Answers

Operators used in select statements are?

0 Answers

Explain atomicity and aggregation?

0 Answers

What is stored in a database?

0 Answers

How to create a database from my program?

0 Answers

how you will identify the mapping level bottleneck ? if there is a mapping level bottleneck then how will you try to improve the mapping

0 Answers

write a query to Find the Maximun second value in table?

5 Answers

What do you mean by dml compiler?

0 Answers

For more Database Management Interview Questions Click Here