查询出三张部门表的总员工数。
版本一:
select(select count(*) from dz)+(select count(*) from phpchina)+(select count(*) from uch) as total from dual;
版本二:
select count(*)+(select count(*) from phpchina)+(select count(*) from uch) as total from dz;(范家鹏)
查询出三张部门表的总员工数。
版本一:
select(select count(*) from dz)+(select count(*) from phpchina)+(select count(*) from uch) as total from dual;
版本二:
select count(*)+(select count(*) from phpchina)+(select count(*) from uch) as total from dz;(范家鹏)