select * from ( select rownum r, comp_name from metatest ) where r >

how to select 5 to 7 rows from a table, which contains 10 rows?

Question Posted / s. ramesh

Answer Posted / s. ramesh

select * from ( select rownum r, comp_name from metatest )
where r > 4 and r < 8;

Is This Answer Correct ?

3 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is query cost in sql server?

996

How many primary keys are possible in a table?

926

What are the advantages of using cte?

1016

between cast and convert which function would you prefer and why?

956

What is the purpose of the master database?

1129

How can you find out how many rows returned in a cursor?

1030

What is federation member?

116

How is sql used in sql server?

1011

how to determine the service pack currently installed on sql server? : Sql server database administration

972

How do clustered indexes store data?

1106

How to create a new schema in a database?

1151

What is field with example?

926

What is repeatable read?

1021

Does the order of columns in update statements matter?

914

When you use @@error and try-catch?

1044