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

Explain forward - only cursors?

1128

What are the events recorded in a transaction log?

1043

How to find table changes in sql server?

1173

What is an sql server agent?

1111

what is database replication? : Sql server database administration

1127

Explain what stored procedure sp_replcounters is used for? : sql server replication

1577

How column data types are determined in a view?

1005

what is normalization? Explain different levels of normalization? : Sql server database administration

1410

What is de-normalization in sql database administration? Give examples?

1024

What are sp_configure commands and set commands?

1072

How to return the top 5 rows from a select query in ms sql server?

1207

Explain throw statement in sql server 2008?

1052

What are click through reports?

147

What is indexed view?

1024

How to resolve the orphan use problem? : sql server security

1070