3.2w+
社区成员
- 主页
- 基础类
- 应用实例
- 新技术前沿
求SQL语句5
SELECT * FROM POWER_METER WHERE FFEATURE IS null WHERE (FMTR_ID LIKE 'TDL_%' or FMTR_ID like 'DDZ_%') 这WHERE 条件怎么写 ？
...全文
当前发帖距今超过3年，不再开放新的回复
发表回复
gagaxiaoyuer 2007-12-27
你一步一步教我 我昨天搞了好久 哈哈没结成功
qiule 2007-12-27
SELECT * FROM POWER_METER WHERE FFEATURE IS null and (FMTR_ID LIKE 'TDL_%' or FMTR_ID like 'DDZ_%')
parss 2007-12-27
SELECT * FROM POWER_METER WHERE FFEATURE IS null and (FMTR_ID LIKE 'TDL_%' or FMTR_ID like 'DDZ_%')
红色部分错误.
红色部分错误.
wzy_love_sly 2007-12-27
小鸟，能不能结个帖？大笨蛋啊
parss 2007-12-27
SELECT * FROM POWER_METER WHERE FFEATURE IS null [color=#FF0000]and (FMTR_ID LIKE 'TDL_%' or FMTR_ID like 'DDZ_%')[/color]
红色部分错误.
红色部分错误.
liangCK 2007-12-27
SELECT * FROM POWER_METER WHERE FFEATURE IS null and (FMTR_ID LIKE 'TDL_%' or FMTR_ID like 'DDZ_%')
dawugui 2007-12-27
SELECT * FROM POWER_METER WHERE FFEATURE IS null and (FMTR_ID LIKE 'TDL_%' or FMTR_ID like 'DDZ_%')
