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

I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration

573

List out what other servers you can use with ssrs?

What is the maximum length of an alert name?

594

Differentiate between sql temp table vs table variable?

507

What are the authentication modes in sql server? How can it be changed?

591

How many types of cursor type are there?

582

What command would you use to add a column to a table in sql server?

739

What is the usage of the sign function?

522

How will you optimize a stored procedure optimization?

502

How to create an inline table-valued function?

527

How can delete duplicate records in cte in sql server?

509

Explain few of the new features of sql server 2008 management studio

515

What is the purpose of data source?

507

what is a traditional network library for sql servers? : Sql server database administration

458

Explain cross join or cartesian product in sql?

536