sql查询员工入职多少天_sql 查询四舍五入_sql怎么四舍五入(22)

%>

Top

上面的人把视图都搬出来了啊不过几乎都是查询，我来点实用的

insert into pbrule(newrid,subj,bz,zf,orid,rstat,layer,bid) select newrid,subj,bz,zf,orid,rstat,layer,bid from pbrule1 where bruleid=bruleid

将pbrule1 表中符合条件的记录 导入 pbrule表中

Top

下面这个更实用，就是两张关联表，删除主表中已经在副表中没有的信息

delete from info where not exists ( select * from infobz where info.infid=infobz.infid )

这条语句就是删除 INFO表中infid字段在infobz中不存在的记录

此语句用来维护很有用哦。

楼主给点分吧

Top

CREATE OR REPLACE PROCEDURE DUMP_TO_WEB_TCLHD_SP_O

AS

BEGIN

CALC_PIA_PRICE ;

DELETE FROM TCLHD_SP_O ;

INSERT INTO TCLHD_SP_O (NAME,CODE,ID,PRICE,TYPE,FIELDS) (

SELECT c.DESCRIPTION,C.SEGMENT1,a.INVENTORY_ITEM_ID, nvl(c.ATTRIBUTE14,'0'),0,nvl(c.ATTRIBUTE13,0)

from mtl_item_categories a , mtl_categories b , mtl_system_items c

where a.CATEGORY_ID = b.CATEGORY_ID and b.SEGMENT1='原材料'

and a.INVENTORY_ITEM_ID = c.INVENTORY_ITEM_ID AND A.ORGANIZATION_ID = 21

and c.ORGANIZATION_ID = 21 and c.inventory_item_status_code = 'Active' );

COMMIT ;

END ;

Top

IBM DB2 》》》SQL

绝对精华

select dmbh,SJDM,flsm,dmzz from ydm where dmbh=3300

union all

select dmbh,SJDM,flsm,dmzz from ydm where dmbh in

(select dmzz from ydm where dmbh=3300)

union all

select dmbh,SJDM,flsm,dmzz from ydm where dmbh in

(select dmzz from ydm where dmbh in (

select dmzz from ydm where dmbh=3300))

union all

select dmbh,SJDM,flsm,dmzz from ydm where dmbh in

(select dmzz from ydm where dmbh in

(select dmzz from ydm where dmbh in (

select dmzz from ydm where dmbh=3300)))

union all

select dmbh,SJDM,flsm,dmzz from ydm where dmbh in

本文来自电脑杂谈，转载请注明本文网址：
https://www.pc-fly.com/a/ruanjian/article-30385-22.html