数据库中查询出空值null设置为0

select s1.company company,IFNULL(s1.department,0) department,s1.position position,s1.name person,IFNULL(s2.oneLevel,0) oneLevel,