34,576
社区成员
发帖
与我相关
我的任务
分享各位大侠:在sql语句中如何滤除查询后的重复字段！！本小妹在线等候！切急！！
SELECT w_storeid
FROM t_temperature
WHERE (w_temperature >
(SELECT a_alarm
FROM t_alarm
WHERE a_month = month(w_time)))
FROM t_temperature
WHERE (w_temperature >
(SELECT a_alarm
FROM t_alarm
WHERE a_month = month(w_time)))
...全文
请发表友善的回复…
发表回复
aierong 2003-09-12
- 打赏
- 举报
distinct
yoki 2003-09-12
- 打赏
- 举报
SELECT distinct w_storeid
FROM t_temperature
WHERE (w_temperature >
(SELECT a_alarm
FROM t_alarm
WHERE a_month = month(w_time)))
FROM t_temperature
WHERE (w_temperature >
(SELECT a_alarm
FROM t_alarm
WHERE a_month = month(w_time)))
snryjian 2003-09-12
- 打赏
- 举报
SELECT distinct w_storeid
FROM t_temperature
WHERE (w_temperature >
(SELECT a_alarm
FROM t_alarm
WHERE a_month = month(w_time)))
