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 is use of except clause? How it differs from not in clause?

971

what are defaults? : Sql server database administration

1005

What are the requirements on sql server network connections?

897

Can you explain about buffer cash and log cache in sql server?

905

How to create an inline table-valued function?

907

Can you explain what is indexed view? How to create it?

851

Should you normalize audio?

879

Which is the main third-party tool used in sql server?

883

Explain use of expression builder.

949

What is row-level compre?

941

What are sub reports?

186

What is user-defined inline table-valued function?

899

What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio

1066

What is the default fill factor value?

1011

What is resource governor in sql server?

948