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

What happens when unicode strings concatenate with non-unicode strings?

1185

What is a covering index?

1043

What is the difference between implicit and explicit transaction?

1052

Tell me the difference between clustered and non-clustered index?

991

what are database files and filegroups? : Sql server database administration

999

What are the main differences between #temp tables and @table variables and which one is preferred?

1134

What are the events recorded in a transaction log?

1046

How connect excel to sql server?

1054

Can group by be used without aggregate functions?

966

What is service broker? : sql server database administration

1031

How can we remove orphan records from a table?

1030

State a few properties of relational databases?

1181

What is a trigger? Why we need it?

1057

What are the different types of join?

1240

How to check parameter value in stored procedure sql server?

1029