how to select 5 to 7 rows from a table, which contains 10 rows?
Answer Posted / ajay (esd)
Please ignore my above answer
select * from tablename where sno between 4 and 8
Ajay
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
How to create an identity column?
Do you know exporting and importing utility?
As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?
What is policy management?
How can you insert null values in a column while inserting the data?
What are the tools available in market as an alternative to sql server reporting services?
How to replace null values in expressions using isnull()?
What is snapshot report?
Is foreign key unique?
What is purpose of normalization?
What is Replication?
Please explain go command in sql server?
How to return the second 5 rows in ms sql server?
What is dbcc updateusage?
Is null vs coalesce?