select * from emp where empid between 5 and 7

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

Question Posted / govind

Answer Posted / govind

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What are the differences between triggers and stored procedures?

1119

how many clustered indexes can be created on a table? : Sql server database administration

1226

Explain the rules for designing files and file groups in sql server?

1022

Explain what is use of dbcc commands?

1136

What is a user-defined function in the sql server and what is its advantage?

1141

What is the order in which the sql query is executed?

994

How do triggers work?

996

Explain DBCC?

1016

How can you insert null values in a column while inserting the data?

1343

What are xml indexes?

1005

How do I perform an unattended install of sql server 2000?

1140

What is difference between unique and primary key?

972

How to start and end transact-sql statements?

1090

Tell me what are the essential components of sql server service broker?

991

What is filtered index?

1145