Interested to Buy Any Domain ? << Click Here >> for more details...
i need query for displaying the eno,ename in a table from row
2 to row 5
- 1 Answers
- 4072 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
Define the relationship between ‘view’ and ‘data independence’.
When should you consider denormalization?
What are the four components of a database system?
What are types of dbms?
Why is normalisation used?
What is considered a database?
What are stored-procedures? And what are the advantages of using them.
What is procedure in database?
How rdbms is different from dbms?
What is dba in dbms?
What is entity relationship diagram?
What are the 4 main objects of a database?
What are the different stages in 'data warehousing'?
What is the difference between star flake and snow flake schema?
What are the three main types of models?
