MySQL if函数实现类似Oracle decode 功能,返回多级数据
SQL语句如下:
SELECT if(timestampdiff(hour, sa.add_time, now()) < 1000,
if(timestampdiff(hour, sa.add_time, now()) < 300,
if(timestampdiff(hour, sa.add_time, now()) < 128, 3 , 2 ) , 1 ) , 0 ) dift...
原创
2018-10-08 16:23:33 ·
904 阅读 ·
0 评论