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

How do you delete a trigger?

951

List the different normalization forms?

960

What is the purpose of the master database?

1103

What is the syntax for encrypting a column in SQL Server?

1101

What are user-defined functions (udfs) in sql server?

968

Explain the first normal form(1nf)?

1004

Differentiate between sql temp table vs table variable?

862

What are information schema views?

957

Can I disable or restrict ssrs export formats (rendering formats)?

148

What is difference between materialized view and view?

896

What is index, cluster index and nonclustered index?

970

How do you migrate data from mssql server to azure?

165

Can you pass expressions to function parameters?

1081

Explain for xml explicit mode?

957

What are the properties of the transaction?

991