雪花

十一、对结果集查询

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
复制代码

 

posted @   十色  阅读(160)  评论(0编辑  收藏  举报
  1. 1 少年 梦然
  2. 2 尘埃 林小柯
  3. 3 飞鸟和禅 任然
  4. 4 Dancing With Your Ghost Sasha Sloan
  5. 5 烟火人间 添儿呗
  6. 6 摘仙 伊格赛听、叶里
少年 - 梦然
00:00 / 00:00
An audio error has occurred, player will skip forward in 2 seconds.
点击右上角即可分享
微信分享提示