Select EmpNo, EName,Sal from EmpTable where EmpNo between 5 and 7

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

Question Posted / pravnch

Answer Posted / pravnch

Select EmpNo, EName,Sal from EmpTable where EmpNo between 5
and 7

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1227

Explain the truncate command?

990

how do you test proper tcp/ip configuration windows machine? : Sql server database administration

1069

What is log in sql server?

1153

Can You Use Data Mining Models In Ssrs?

146

Where is localdb stored?

947

What are the different types of normalization?

1168

Can a table be created inside a trigger?

974

What are the properties of the relational tables?

881

What are the tables in sql?

1091

What is sql sandbox in sql server?

1236

After removing a table from database, what other related objects have to be dropped explicitly?

1064

How many triggers are possible per table?

1104

What are different types of statement?

1021

What is the maximum number of instances in 32 bit and 64 bit sql server 2012?

987