常用SQL

--选出相同行
SELECT *
FROM I_KHXXGZSJWH a
WHERE ( ( SELECT COUNT(*)
FROM I_KHXXGZSJWH
WHERE KEHBM = a.KEHBM
) > 1 )
ORDER BY KEHBM DESC


--选出某列 求和
SELECT SUM(LJKPJE) from I_KPXX WHERE WBSYS='S-201401012.A';


--删除流程脚本
begin
use H3Cloud
delete from OT_InstanceContext
delete from OT_Token
delete from OT_WorkItem
delete from OT_Attachment
DELETE FROM [dbo].[I_电脑信息更新后子表]
DELETE FROM [dbo].[I_电脑信息更新前子表]
DELETE FROM [dbo].[I_机房硬件更新后子表]
DELETE FROM [dbo].[I_机房硬件更新前子表]
DELETE FROM [dbo].[I_加班备案记录_GROUP1]
end
begin
use H3
delete from dbo.ActivityMap
end

 --查询表objectID字段的最大值+1作为ObjectID字段输出
 SELECT MAX(convert(INT,ObjectID))+1 AS ObjectID FROM I_KHXXGZSJWH