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

How to generate create procedure script on an existing stored procedure?

What is database replication?

How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication

where the connection string store in the database

Can select statements be used on views in ms sql server?

How will you know when statistics on a table are obsolete?

what's the difference between a primary key and a unique key? : Sql server database administration

Do you know what is difference between index seek vs. Index scan?

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

How to connect a database with sql express.?

Is sql server implemented as a service or an application? : Sql server database administration

Tell me what are cursors and when they are useful?

For more SQL Server Interview Questions Click Here