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

Write a program using SQL queries to find a unique entry in a table.

How to generate create view script on an existing view?

What are magic tables in sql server?

What are the different types of sql server replication? : sql server replication

Is the order of columns in the set clause important in ms sql server?

Explain what are the events recorded in a transaction log?

How many triggers are possible per table?

What is logshipping and its purpose?

Do you know sql server 2008 backup compression?

What is 3nf normalization form?

I Have Employee table having column name as ID,SALARY how to get second max salary from employee table with id ex ID SALARY 1 20000 7 37000 2 5000

Do you know what are acid properties of transaction?

For more SQL Server Interview Questions Click Here