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
What is cursor explain with example?
Is pl sql useful?
What is primary key secondary key alternate key candidate key?
What does the file extension accdb stand for?
what is the difference between inner and outer join? Explain with example. : Sql dba
What is linq to sql?
How do you optimize a query?
What is the non-clustered index in sql?
What is number function in sql?
How can I speed up sql query?
How does index help in query performance?
Is sql procedural language?
How do I create an index in word?
Why do we use procedures in pl sql?
What is the difference between clustered and non-clustered indexes?