凝enenenenenen
凝enenenenenen
全部文章
分类
题解(1)
归档
标签
去牛客网
登录
/
注册
凝enenenenenen的博客
全部文章
(共1篇)
题解 | #获取有奖金的员工相关信息。#
SELECT DISTINCT emp_no,first_name,last_name,btype,salary,(CASE WHEN btype = 1 THEN salary0.1 WHEN btype = 2 THEN salary0.2 ELSE salary*0.3 END) bonusF...
2021-05-19
0
466