select * from (select rownum rm,id from emp where rownum<=9) where rn &g

display records from 5 to 9 using rowid or rownum

Question Posted / hari

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

Please Help Members By Posting Answers For Below Questions

What is embedded sql what are its advantages?

962

What are different types of triggers?

1029

What is not in sql?

901

What is the current version of postgresql?

1007

Can you call pl/sql package functions from within a fast formula?

977

What is plpgsql language?

980

Which is better cte or subquery?

970

How to run pl sql program in mysql?

942

What is a temp table?

950

Can a foreign key be null?

1033

What is the difference between microsoft access and sql?

961

What are the two different parts of the pl/sql packages?

1026

Is a view faster than a stored procedure?

902

What is benefit of creating memory optimized table?

910

What is nosql db?

926