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 command would you use to add a column to a table in sql server?

1356

Explain what is raid and what are different types of raid levels?

1087

Which tcp/ip port does sql server run on? How can it be changed?

1080

Explain query editor regions

1108

What does dml stand for?

994

What are the difference between primary keys and foreign keys?

1013

How to create user messages with print statements in ms sql server?

1030

What is bcp? When does it use?

987

What is inline variable assignment?

1080

Is sql server a database?

1037

What is named query? : sql server analysis services, ssas

1002

What are policy management terms?

1039

Do you know data definition language, data control language and data manipulation language?

1086

What are wait types?

1198

What is data source object?

1064