十一、对结果集查询

2

select top 1
case when (LimitName='渠道代理商') then CreateUser
else '' end
from tbl_admin where dealflag=0 and AdminName = 'WHJR055'


select amount,number,
case when (amount>1000) then 'big'
when (amount< 1000) then 'small'
else '0' end
from TABLENAME