张多盐

题解

/ 注册

全部文章 / 题解（共2篇）

题解 | #获取有奖金的员工相关信息。#

select a.emp_no,e.first_name,e.last_name,btype,salary ,case when btype = 1 then salary* 0.1 when btype = 2 then salary* 0.2 else salary*0...

Sqlite

2021-11-01

0 282

题解 | #获取有奖金的员工相关信息。#

select a.emp_no,e.first_name,e.last_name,btype,salary ,case when btype = 1 then salary* 0.1 when btype = 2 then salary* 0.2 else salary*0...

Sqlite

2021-10-29

0 266