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

How can you fetch alternate records from a table?

540

how would you troubleshoot blocking? : Sql server database administration

520

What are different types of constraints?

509

Can sql servers linked to other servers?

547

Can we write trigger for view?

555

Which Model uses the SET concept

579

Explain features of analysis services?

523

How do I find the sql server version?

518

How to copy the tables, schema and views from one sql server to another?

554

How many databases instances are there in sql server 2000?

579

How do I create a trace in sql server?

512

What happens if strings are casted into wrong code pages in ms sql server?

564

What happens if null values are involved in arithmetic operations?

582

What is merge statement?

625

Explain query editor regions

613