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

Question Posted / durga prasad

Answers were Sorted based on User's Feedback

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

select * from emp where empid >=5 and empid <=7

Is This Answer Correct ?

3 Yes

9 No

More SQL Server Interview Questions

Explain about local stored procedure?

Explain about thread and memory management process of SQL?

What is “asynchronous” communication in sql server service broker?

Can coalesce return null?

What is collation sensitivity? Explain different types.

How do you know if sql server is running on your local system?

What are the types of processing and explain each? : sql server analysis services, ssas

In which situation you use Self joins?

Tell me what are the essential components of sql server service broker?

What is an example of a foreign key?

How to transfer data from a cursor to variables with a "fetch" statement?

What is plan freezing?

For more SQL Server Interview Questions Click Here