How to use loop in where condtion in T-SQL query?

Question

select * from student where roll-no in (30 to 50)

student is table name, roll_no, first_name, last_name, add are columns

How to print student details whose roll no between 30 to 50?

Hannah Vernon · Accepted Answer · 2013-12-06 05:29:33Z

1

You need to use a where clause with a range like:

 select * from student where [roll-no] >= 30 and [roll-no] <= 50;

answered Dec 6, 2013 at 5:29

Hannah Vernon

3,4711 gold badge34 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

juergen d · Accepted Answer · 2013-12-06 07:41:33Z

0

 select * from student 
 where roll-no between 30 and 50

answered Dec 6, 2013 at 7:41

juergen d

205k40 gold badges303 silver badges377 bronze badges