康博常用sql语句.docVIP

康博常用SQL语句 grant?connect,resource,create?any?view,create?any?synonym,create?database?link,select?any?table,create?table,update?any?table,insert?any?table,delete?any?table,alter?any?tableto?combrain;GRANT???????????????????????????????????????????????????????????EXECUTE?ANY?PROCEDURE??????????????????????????????????????????????????????????to?COMBRAIN; 1、select itemdoc.it_id 编号, itemdoc.itname 品名, max(itemdoc.spec) 规格, max(itemdoc.unit) 单位, max(itemdoc.madein) 产地, sum(td.sale_amt) 销量, sum(td.sale_mny) 金额 from sd_salelog t inner join sd_salelogd td on t.salelog_no = t