how to select 5 to 7 rows from a table, which contains 10 rows?
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 |
Post New Answer View All Answers
What is normalization? Describe its different types.
How to create a login account in ms sql server to access the database engine using "create login" statements?
What are distributed partitioned views?
How you trouble shoot when any job fails
How to use the inserted and deleted pseudo tables?
What is cross join in sql server joins?
What is dimension table? : sql server analysis services, ssas
What is sql or structured query language?
What is the difference between insensitive and scroll cursor?
Which language is supported by sql server?
there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration
What is scan table/view and seek table/view when its occurs? : sql server database administration
What are “phantom rows”?
What are .mdf files?
What is the tcp/ip port on which sql server runs?