Employee Bonus
找獎金低於1000的員工姓名和獎金金額,有回傳null
=======雷=======
=======雷=======
=======雷=======
=======雷=======
=======雷=======
=======雷=======
=======雷=======
=======雷=======
=======雷=======
select [name],bonus
from Employee left join Bonus on
Employee.empId = Bonus.empId
where bonus < 1000 or bonus is NULL
請先 登入 以發表留言。