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
3983 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 purpose of queries in a database?

0 Answers

Explain what are tp-lite and tp-heavy monitors?

0 Answers

Define ddl and dml.

0 Answers

What is the difference between horizontal and vertical partitioning?

0 Answers

How do I create a database in access 2010?

0 Answers

Explain a join between tables?

0 Answers

What is SQL FORMS ?

1 Answers CCIL,

Can we use a Restricted packaged procedure in WHEN_TEXT_ITEM trigger ?

1 Answers

Explain the hierarchical database?

0 Answers

What does rdbms stand for?

0 Answers

What is index and also explain types of indexing in dbms?

0 Answers

What are service-specific middleware?

0 Answers

For more Database Management Interview Questions Click Here