某列不为null也不为空:
xx is not null and xx<> ‘’
select dept_code, user_acc from Employee
where dept_code IS NOT NULL and dept_code<> ''
and user_acc IS NOT NULL and user_acc<> ''
order by dept_code
某列不为null也不为空:
xx is not null and xx<> ‘’
select dept_code, user_acc from Employee
where dept_code IS NOT NULL and dept_code<> ''
and user_acc IS NOT NULL and user_acc<> ''
order by dept_code