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
- 3978 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
Why indexing is used in database?
Explain top-n analysis in DBMS.
Enlist ways to efficiently code transactions.
What do you understand by proactive, retroactive and simultaneous update?
What is 2nf and 3nf?
What entity means?
What does fill factor concept mean with respect to indexes?
Define union all operator and union.
How to get a book from database MS access that contain 'i' charactor in it's name like internetbook or networkingbook. what will be java query for this purpose?
What is tuple in rdbms?
Can group by and ordered by used in a single query?
What is natural key?
Define database.
What are the two major subsystems of system r?
What do you mean by dml compiler?
