ans 1 - select * from ( select rownum num , empno, ename from emp

i need query for displaying the eno,ename in a table from row
2 to row 5

Question Posted / mahesh

1 Answers
4189 Views
I also Faced
E-Mail Answers

Answer Posted / mahesh

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 View All Answers

Please Help Members By Posting Answers For Below Questions

What is service based database?

939

Explain the different types of database keys?

1021

What is meant by database system?

963

what do u mean by implementation?

2219

Explain 3nf?

1000

What is a candidate key in dbms?

1138

Is a server a database?

960

How to pump the data from one database to another?

971

Discuss some of the techniques that can be used to tune operational performance.

1011

How easy is netlib to use?

1047

List few ways to code transactions in an efficient manner?

962

What is an image database?

994

What are stand-alone procedures?

1003

What is database Configuration assistant ?

1197

What is the definition of database management system?

1121