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
- 4104 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
What are the features of openedge features?
Write a query to create a duplicate table with and without data present?
What are some of the important security features of a dbms?
What is the purpose of normalisation?
How to extract metadata for the entire database?
Is google scholar a database?
Describe reporting lifecycle?
What is the role of tables in database?
State at least four kinds of indexing?
What is denormalization and why would someone consider doing so?
What is the use of database management system?
dear sir please provide what question will be asked in bank it officer interview
When would you use a database?
What is delimiter in dbms?
What is meant by database server?
