我偶然遇到了查询来计算SO声誉的CDF:
SELECT
Reputation,
SUM(COUNT(*)) OVER(
ORDER BY Reputation
ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS UserCount
FROM
Users
GROUP BY Reputation
ORDER BY Reputation
我制作了自己的查询,看起来像
select reputation, cume_dist() over (order by reputation)
from users
gro
我正在使用nodejs。在创建一个普通的sql查询时,我得到了这样的结果:
var id = req.body.id;
var query = "select from table where id = " + id;
现在,我所知道的是你应该这样转义integer:
var id = parseInt(req.body.id);
对吗?或者你应该像一根绳子一样转义?或者根本不逃脱?
我已经正确地配置了DKIM、SPF和DMARC,从电子邮件头看,它似乎工作正常,但我从SMTP服务器发送的电子邮件被标记为垃圾邮件。这是我的电子邮件标题
Received: from SG2APC01HT253.eop-APC01.prod.protection.outlook.com
(10.163.105.24) by SG2PR03MB1582.apcprd03.prod.outlook.com with HTTPS via
SG2PR06CA0014.APCPRD06.PROD.OUTLOOK.COM; Tue, 7 Feb 2017 02:03:11 +0000
Received
如果我的表的值为1,则尝试显示它的列名
| A | B | C | D |
| 0 | 1 | 1 | 0 |
在这种情况下,我想得到以下结果:
| Column |
| B |
| C |
我编写了以下查询,但它不起作用:
SHOW COLUMNS
FROM `questions`
WHERE VALUES=`1`