display records from 5 to 9 using rowid or rownum
Answer Posted / hari
select * from (select rownum rm,id from emp where rownum<=9) where rn >=5)
Is This Answer Correct ? | 4 Yes | 5 No |
Post New Answer View All Answers
Explain the difference between rename and alias?
Why truncate is faster than delete?
Is sql low level language?
What is trigger types in sql?
What is oracle sql called?
Why is sql*loader direct path so fast?
Why indexing is needed?
What are the types of operators available in sql?
What is the difference between join and natural join?
How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?
What is before trigger?
How do you delete data from a table?
Can we create a trigger on view?
Why do we need databases?
what are date and time functions in mysql? : Sql dba