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 / guest

Answer Posted / guest

Is This Answer Correct ?

7 Yes

9 No

Please Help Members By Posting Answers For Below Questions

What is row_number () and partition by in sql server?

1081

Do you know what are the reporting services components?

976

What is the meaning of resultset type_scroll_insensitive?

956

What is scd (slowly changing dimension)? : sql server analysis services, ssas

1008

How to create and drop temp table in sql server?

1052

What is an entity-relationship diagram (erd)?

1214

What are extended events in sql server?

955

What is the security principal at the database level that represents your session?

942

What is the simplest way to create a new database in ms sql server?

1010

What are the lambda triggers?

905

What stored by the tempdb ? : sql server database administration

1048

How to test values returned by a subquery with the in operator?

1197

What command do we use to rename a database?

1078

How to delete duplicate rows from table except one?

989

What is transaction server isolation?

1039