db2常用语句

连接数据库

db2 connect to chmgmdb user ch_mgm

断开数据库

db2 disconnect current

查询

db2 "select * from btpoper where brhid='907020000' and oprid='0001'"
db2 "select oprid,oprnm,brhid,passwd from btpoper"

显示表前10行

select * from <表名> fetch first 10 rows only

查看当前数据库表空间分配状况

db2 list tablespaces show detail

 联表查询

left join

排序

group by