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

How to receive output values from stored procedures?

1135

What are the different Authentication modes in SQL Server and how can you change authentication mode?

1081

How to loop through result set objects using odbc_fetch_row()?

972

Explain multiserver query

1034

What are the different types of collation sensitivity?

1117

What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?

1166

How to get the definition of a user defined function back?

1042

How to create an multi-statement table-valued function?

989

What is the osql utility?

951

What is explicit cursors?

1063

what are the new features in SSRS?

134

Explain how you can configure a running aggregate in SSRS?

163

Explain security with sql azure?

186

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

1096

How to update a field in SQL after ALTERING a row?

1230