Database Management Question: Download Questions PDF
How to displaying the eno, ename in a table from row
2 to row 5?
Answer:
select *
from (
select rownum num , empno, ename
from emp
)
where num between 2 and 5
------------------
we can also use row_number function
from (
select rownum num , empno, ename
from emp
)
where num between 2 and 5
------------------
we can also use row_number function
Download Database Management Interview Questions And Answers
PDF
Previous Question | Next Question |
What is datapump? | Which acid property will effect when we use commit in trigger? |