SELECT * from emp_table WHERE e_id>=5 AND e

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

Question Posted / kaviraj.y

Answer Posted / kaviraj.y

SELECT * from emp_table WHERE e_id>=5 AND e_id<=7;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain why variables called the most powerful component of ssis?

538

How to Update from select query in sql server?

550

what's the information that can be stored inside a bit column? : Sql server database administration

529

Find columns used in stored procedure?

529

What are triggers in ms sql server?

606

What are types of storage modes? : sql server analysis services, ssas

587

List the different types of joins?

572

Explain how you can deploy an SSRS report?

106

How to grant a permission in ms sql server using "grant execute" statements?

569

What is msdb database? : SQL Server Architecture

542

Tell me what is sql profiler?

630

What is snapshot parameter in ssrs?

109

Explain the difference between delete,drop and truncate in SQL Server?

592

What are the 3 types of schema?

604

What is a derived table?

518