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 the index requirement in SQL Azure?

What is the use of commit?

1007

Explain transaction server auto commit?

1047

What is a collation?

1100

What are the differences between triggers and stored procedures?

1074

What are the different methods available under sqlcommand class to access the data?

1128

what are isolation levels? : Sql server database administration

1005

How would you add a section to a table?

1062

List the different index configurations possible for a table?

939

What are the dmvs? : sql server database administration

1070

What is tempdb database? : SQL Server Architecture

1206

Explain different types of collation sensitivity?

989

What is a trigger in sql server?

1186

Which sql server is best?

1004

Explain primary key, foreign key and unique key?

999