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

When columns are added to existing tables, what do they initially contain?

1012

Write an sql query for deleting duplicate rows?

979

How can you check the level of fragmentation on a table?

1030

Explain an incremental backup?

973

How to insert new line characters into strings?

967

What are the advantages of sql azure?

140

Can truncate be rolled back?

915

What are parameterized reports?

198

What is the correct order of the logical query processing phases?

917

how many type of indexing in database?

966

can you instantiate a com object by using t-sql? : Sql server database administration

981

what is the different types of backups available in sql server? : Sql server database administration

908

Tell me what is difference between clustered and non clustered index?

930

What is service broker? : sql server database administration

973

What are recommended options to be used while using db mirroring? : sql server database administration

1124