tranch's recent timeline updates
tranch

tranch

V2EX member #48224, joined on 2013-10-29 14:47:32 +08:00
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))
About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Solana   ·   5939 Online   Highest 6679   ·     Select Language
创意工作者们的社区
World is powered by solitude
VERSION: 3.9.8.5 · 28ms · UTC 02:14 · PVG 10:14 · LAX 19:14 · JFK 22:14
♥ Do have faith in what you're doing.