select * from (select rownum r ,a.* from emp a ) where r between 5 and 9

display records from 5 to 9 using rowid or rownum

Question Posted / chiru

Answer Posted / chiru

Is This Answer Correct ?

7 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the difference between inner join and left join?

1036

What does over partition by mean in sql?

1039

How do I run a sql query in pgadmin 4?

999

Is sql easier than java?

1065

What are the types of variables use in pl sql?

1083

How many developers work on postgresql?

1038

How do I enable sql encryption?

1068

what are the differences between char and varchar? : Sql dba

1111

how to convert dates to character strings? : Sql dba

1247

How do I view tables in mysql?

1027

What are the types pl/sql code blocks?

1191

How do I run a program in pl sql?

1053

what is commit? : Sql dba

1121

How do I install microsoft sql?

1111

What is difference between primary and secondary key?

1072