Please ignore my above answer select * from tablename where sno between

how to select 5 to 7 rows from a table, which contains 10 rows?

Question Posted / ajay (esd)

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

Please Help Members By Posting Answers For Below Questions

Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?

953

how to determine the service pack currently installed on sql server? : Sql server database administration

976

What are the restrictions that views have to follow? : SQL Server Architecture

1003

What do you understand by integration services in sql server?

965

How to change server name in sql server?

1188

What are database states in ms sql server?

1183

What are the differences between decimal and float in ms sql server?

1253

Mention the differences between substr and charindex in sql server.

1055

What is the command used to recompile the stored procedure at run time?

1083

What is policy based management (pbm)? : sql server database administration

991

Can you import Microsoft Excel data to SSRS?

132

Can two tables have the same primary key?

1213

How much is a sql server license?

960

Tell me about normalization in DBMS.

998

Explain important index characteristics?

1038