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

What happens when converting big values to numeric data types?

What is the disadvantages of index?

What is normalization and what are the different forms of normalizations?

Explain an incremental backup?

Diffrence between DTS vs SSIS

How can we delete a table in sql server?

Difference Between ORDER BY Clause and GROUP BY Clause in SQL?

What are the purposes and advantages stored procedure?

What is resource governor in sql server?

Is trigger fired implicitely?

What is Dedicated Administrator Connection in sql server 2005?

How to drop an existing table?

For more SQL Server Interview Questions Click Here