i need query for displaying the eno,ename in a table from row
2 to row 5
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
What is end users in dbms?
What does clipper stand for?
When does checkpoint occur?
What is second normal form?
How to do replication of firebird databases?
Explain the difference between physical and logical data independence?
Is it good to save image in database?
Why is normalisation used?
What is 1nf?
What is 2nf in dbms?
What are the different types of data tables?
What does you mean by s4 super key?
How many types of users in dbms?
i have a web page and in this page i create 3 textbax and a "summit" button do you have any html code for add text velue in my web page like link summation(form) sites.
What is the purpose of reports in a database?