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 to rebuild master databse?

1074

What is a bit datatype?

979

What is in place upgrade in sql server?

1035

Can an automatic recovery be initiated by a user?

996

Explain forward - only cursors?

1049

What is an inner join?

975

Does a sql server 2005 select statement require a from?

1014

what is difference between view and Dip.

2405

What is the osql utility?

950

How to deploy the Report?

138

Explain what are magic tables in sql server?

988

What is clustered primary key?

1008

What are the differences between web role and worker role?

122

What is catalog views?

1063

What are the operating modes in which database mirroring runs?

1076