display records from 5 to 9 using rowid or rownum
Answer Posted / chiru
select * from (select rownum r ,a.* from emp a ) where r between 5 and 9
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What is the difference between inner join and left join?
What does over partition by mean in sql?
How do I run a sql query in pgadmin 4?
Is sql easier than java?
What are the types of variables use in pl sql?
How many developers work on postgresql?
How do I enable sql encryption?
what are the differences between char and varchar? : Sql dba
how to convert dates to character strings? : Sql dba
How do I view tables in mysql?
What are the types pl/sql code blocks?
How do I run a program in pl sql?
what is commit? : Sql dba
How do I install microsoft sql?
What is difference between primary and secondary key?