i need query for displaying the eno,ename in a table from row
2 to row 5
- 1 Answers
- 3476 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
Mention a query to calculate the even and odd records from a table
What is sonicmq?
How many types of database language exist?
How is view stored in database?
What is third normal form?
Who is communication horizons?
Enlist the types of cursor?
What are its two major subsystems of r?
Explain the components of rdbms?
Explain about cursors?
How to load a file into database column?
How are exceptions handled in pl/sql? Give some of the internal exceptions name?
What is database definition (dbd)?
Is the server accepting tcp ip connections on port 5432?
What do you mean by extension and intension?
