db2
select dpt_no||dpt_nam from db2admin.bsdptms
或者
select dpt_no CONCAT dpt_nam from db2admin.bsdptms
oracle
select dpt_no||dpt_nam from db2admin.bsdptms
或者
select concat(dpt_no,dpt_nam) from db2admin.bsdptms
informix
select dpt_no||dpt_nam from db2admin.bsdptms
sybase
select dpt_no||dpt_nam from db2admin.bsdptms
access
select dpt_no+dpt_nam from db2admin.bsdptms
foxpro
select dpt_no+dpt_nam from db2admin.bsdptms
SQLSERVER
select dpt_no||dpt_nam from db2admin.bsdptms
|
