--正确的SQL语句,查询结果:746 SELECT COUNT(1) FROM EHR_BASE EB, EHR_HF_INDICATOR EHI WHERE EB.EHR_ID=EHI.EHR_ID AND EB.CANCELLED = '1' AND EB.DEATH = '1' AND EB.MOVED_OUT = '1' AND EB.MNG_ORG_CODE LIKE '0203%' AND MNG_ORG_NAME = '北京市西城区新街口社区卫生服务中心' AND EB.CD_DIABETES_MELLITUS = '1' AND (EHI.FBG >= 7 OR EHI.FBG = -1)/*血糖FBG>=7或者FBG=-1*/ --错误的SQL语句查询结果:123010267 SELECT COUNT(1) FROM EHR_BASE EB, EHR_HF_INDICATOR EHI WHERE EB.EHR_ID=EHI.EHR_ID AND EB.CANCELLED = '1' AND EB.DEATH = '1' AND EB.MOVED_OUT = '1' AND EB.MNG_ORG_CODE LIKE '0203%' AND MNG_ORG_NAME = '北京市西城区新街口社区卫生服务中心' AND EB.CD_DIABETES_MELLITUS = '1' AND EHI.FBG >= 7 OR EHI.FBG = -1
DB2数据库中SQL语句中使用or和and的关键字的时候注意事项
免责声明:文章转载自《DB2数据库中SQL语句中使用or和and的关键字的时候注意事项》仅用于学习参考。如对内容有疑问,请及时联系本站处理。
上篇如何杀死linux-zombie僵尸进程Struts2类型转换器下篇
宿迁高防,2C2G15M,22元/月;香港BGP,2C5G5M,25元/月 雨云优惠码:MjYwNzM=