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 ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How do I clean up sql server transaction log?

1123

What is sql server programming?

1090

Explain transaction server distributed transaction?

1036

What is recompile sql server?

1079

Does index speed up select statements?

1073

Explain what is the difference between union and union all?

1070

what is the difference between delete table and truncate table commands? : Sql server database administration

1079

How self join is different from outer join?

1175

What number aggregate functions are accessible there in sql?

1130

Explain linked server in sql?

1292

what is the system function to get the current user's user id? : Sql server database administration

1069

How to transfer a table from one schema to another?

1045

How to enable tcp/ip protocol on a sql server?

1210

How do I view a stored procedure in sql server query?

978

What is difference between equi join and inner join?

1038