sql if whilse

在这里插入代码片declare @1  int=1
while @1<51
begin
set @1=@1+1
if @1%2!=0
print @1
end
declare @tt int = 30
if @tt between 10  and 20
print '小团体'
else if @tt between 20 and 30
print '中团体'
else if @tt between 30 and 50
print '大团体'
else 
print '零散人员'