一些sql语句
来源:互联网 发布:十禾淘宝运营怎么样 编辑:程序博客网 时间:2024/06/11 15:13
select a._id,a.innerId,(select entpName From android_pucEntp c where c.innerID=a.innerId) entpName,b.checkUnit,c._id troubleId,a.entpTypeId,a.checkItemId,c.improveStep,c.improveUnit,c.finishDate,c.closeFlag,c.checkDate From android_govCheckInspectCheckContent a ,android_insRecord b,android_govtroubleregcheck c where a.inspectID=b._ID and a._id=c.inspectId
and (c.checkDate>date() or c.finishDate>date() or c.checkDate='')and c.closeFlag is null and improveunit is null and a.innerId=8129
and (c.checkDate<date() and c.checkDate<>'' and c.closeFlag is null or c.finishDate<date() and c.finishDate<>'' and c.closeFlag is null) and a.innerId=8129
and c.finishDate<date() and c.finishDate<>'' and c.closeFlag is null or c.checkDate<date() and c.checkDate<>'' and c.closeFlag is null
update android_govTroubleRegCheck set checkdate='2014-05-20' where _id=119
select improveunit,finishDate,* from android_govTroubleRegCheck where finishDate>date()
finishDate<date() and finishDate<>'' and closeFlag is null or checkDate<date() and checkDate<>'' and closeFlag is null
select c.savetime,a._id,a.innerId,(select entpName From android_pucEntp c where c.innerID=a.innerId) entpName,b.checkUnit,c._id troubleId,a.entpTypeId,a.checkItemId,c.improveStep,c.improveUnit,c.finishDate,c.closeFlag,c.checkDate,b.assistExecuter from android_govCheckInspectCheckContent a ,android_insRecord b,android_govtroubleregcheck c where 1=1 and a.inspectID=b._ID and a._id=c.inspectId and a.troubleType=1 and a.innerId=528959 order by c.saveTime desc
and (c.checkDate>date() or c.finishDate>date() or c.checkDate='')and c.closeFlag is null and improveunit is null and a.innerId=8129
and (c.checkDate<date() and c.checkDate<>'' and c.closeFlag is null or c.finishDate<date() and c.finishDate<>'' and c.closeFlag is null) and a.innerId=8129
and c.finishDate<date() and c.finishDate<>'' and c.closeFlag is null or c.checkDate<date() and c.checkDate<>'' and c.closeFlag is null
update android_govTroubleRegCheck set checkdate='2014-05-20' where _id=119
select improveunit,finishDate,* from android_govTroubleRegCheck where finishDate>date()
finishDate<date() and finishDate<>'' and closeFlag is null or checkDate<date() and checkDate<>'' and closeFlag is null
select c.savetime,a._id,a.innerId,(select entpName From android_pucEntp c where c.innerID=a.innerId) entpName,b.checkUnit,c._id troubleId,a.entpTypeId,a.checkItemId,c.improveStep,c.improveUnit,c.finishDate,c.closeFlag,c.checkDate,b.assistExecuter from android_govCheckInspectCheckContent a ,android_insRecord b,android_govtroubleregcheck c where 1=1 and a.inspectID=b._ID and a._id=c.inspectId and a.troubleType=1 and a.innerId=528959 order by c.saveTime desc
0 0
- 一些sql 语句
- 一些sql 语句
- 一些Sql语句
- 一些sql语句
- 一些sql语句
- 一些sql 语句
- 一些有用SQL语句
- 一些SQL语句
- sql一些语句
- 一些SQL语句
- sql的一些语句
- 一些T-SQL语句
- 一些SQL语句
- Oracle 一些SQL语句
- sql一些语句
- 一些sql语句
- 一些Sql语句
- 一些SQL操作语句
- android批量插入数据(使用事务)
- Eclipse手动集成svn插件以及svn403错误解决办法
- android新手上路(一)---字符串为空的检测
- 记录自己常写的一些sql语句
- 常写的一些sql语句
- 一些sql语句
- 控制form表单提交
- android新手上路(二)--- 关于findViewById 返回为空
- hdu 3451——Beat drop
- 保持 Flash Player 背景運作 FPS 技巧
- 10.9 Generate Parentheses
- 网页上嵌入Flash播放器(2)
- 带三角形的pop
- 【字符串计算】#STC 1 A. Ball Game