tranch's recent timeline updates tranch's recent timeline updates |
tranchV2EX member #48224, joined on 2013-10-29 14:47:32 +08:00 |
| Talas Solutions – 高级 Python 工程师 酷工作 • tranch • Feb 23, 2023 • Lastly replied by asaarashi | 1 |
tranch's recent replies
Mar 18, 2015 Replied to a topic by gmgardus › 问与答 › fastssh.com 这家是不是蜜罐 |
Dec 10, 2014 Replied to a topic by xiyangyang › 问与答 › Mysql 查询语句怎么写？ |
建议把以上问题贴到问答网站（比如 segmentfault.com）上去讨论，这里不适合发代码。
Dec 10, 2014 Replied to a topic by 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