select * from emp where empid >=5 and empid <=7

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

Question Posted / sam

Answer Posted / sam

Is This Answer Correct ?

3 Yes

9 No

Please Help Members By Posting Answers For Below Questions

How to list all triggers in the database with sys.triggers in ms sql server?

1013

Can you explain powershell included in sql server 2008?

890

what stored procedure can you use to display the current processes? : Sql server administration

959

What is an inner join?

914

How can i Relate Tables in SSIS

1032

What are different types of data sources?

934

Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication

980

Write query to return all rows sql?

1004

How to find the service pack installed? : sql server database administration

970

tell me what is blocking and how would you troubleshoot it? : Sql server database administration

844

What is dknf in normalization form?

983

What is the maximum size per database for sql server express?

972

Working with TLogs

1783

What is the recovery model? List the types of recovery model available in sql server?

842

What is tablesample?

1026