随笔分类 -  SqlServer

sqlserver case when
摘要：SELECT STUDENT_NAME, (CASE WHEN score < 60 THEN '不及格' WHEN score >= 60 AND score < 80 THEN '及格' WHEN score >= 80 THEN '优秀' ELSE '异常' END) AS REMARKFRO 阅读全文
posted @ 2021-08-20 15:27 鱼腥草， 阅读(63) 评论(0) 推荐(0) 编辑

点击右上角即可分享
微信分享提示