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

Why is maintaining a database important?

0 Answers

Whats is an OLTP Database

0 Answers Microsoft,

What are the package used in DBMS ?

0 Answers

What is the largest component of a database?

0 Answers

What are the features of database language?

0 Answers

Explain the architecture of reporting services?

0 Answers

Where is database stored?

0 Answers

Why do we need foreign key?

0 Answers

what is difference between 1.append to media 2.overright the existing media when we take back up in sql server2000

0 Answers Indian Web Technology,

What is the best database to use?

0 Answers

What is the use of FULL option in EXP command ?

1 Answers

Explain the hierarchical database?

0 Answers

For more Database Management Interview Questions Click Here