tranch 最近的时间轴更新 tranch 最近的时间轴更新 |
tranchV2EX 第 48224 号会员，加入于 2013-10-29 14:47:32 +08:00 |
| Talas Solutions – 高级 Python 工程师 酷工作 • tranch • 2023-02-23 09:44:50 AM • 最后回复来自 asaarashi | 1 |
tranch 最近回复了
2015-03-18 02:25:57 +08:00 回复了 gmgardus 创建的主题 › 问与答 › fastssh.com 这家是不是蜜罐 |
2014-12-10 13:43:33 +08:00 回复了 xiyangyang 创建的主题 › 问与答 › Mysql 查询语句怎么写？ |
建议把以上问题贴到问答网站（比如 segmentfault.com）上去讨论，这里不适合发代码。
2014-12-10 13:14:44 +08:00 回复了 xiyangyang 创建的主题 › 问与答 › Mysql 查询语句怎么写？ |
SELECT section_unique_id AS "section_unique_id",
COUNT(*) AS "hit"
FROM responses
WHERE (response_no,
survey_id,
interview_date) IN
(SELECT DISTINCT response_no,
survey_id,
interview_date
FROM responses
WHERE question_label IN ("Q2A", "Q2B", "Q2C", "Q2B", "Q2D", "Q2E", "Q2F", "Q2G", "Q2H", "Q2I", "Q5", "Q6")
AND value IN (1, 8, 9))
COUNT(*) AS "hit"
FROM responses
WHERE (response_no,
survey_id,
interview_date) IN
(SELECT DISTINCT response_no,
survey_id,
interview_date
FROM responses
WHERE question_label IN ("Q2A", "Q2B", "Q2C", "Q2B", "Q2D", "Q2E", "Q2F", "Q2G", "Q2H", "Q2I", "Q5", "Q6")
AND value IN (1, 8, 9))
Select Language