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

How to add more data to the testing table in ms sql server?

1057

what is normalization? Explain different levels of normalization? : Sql server database administration

1288

What are the events recorded in a transaction log?

980

Explain intellisense for query editing

1014

What is use of except clause? How it differs from not in clause?

1001

What are the differences between user defined functions and stored procedures?

1047

What is the difference between DATETIME2 and DATETIME?

1059

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

1033

What is normalization of database? What are its benefits?

1010

What is a mutating table error and how can you get around it?

1025

What are the types of database schema? : sql server analysis services, ssas

1107

If the job running very slow what is the action you do

1875

Why do we use sql limitations? Which constraints can we use while making a database in sql?

1062

Explain what are the database objects? : SQL Server Architecture

1056

Which joins are sql server default?

977