我偶然遇到了查询来计算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
如果我的表的值为1,则尝试显示它的列名
| A | B | C | D |
| 0 | 1 | 1 | 0 |
在这种情况下,我想得到以下结果:
| Column |
| B |
| C |
我编写了以下查询,但它不起作用:
SHOW COLUMNS
FROM `questions`
WHERE VALUES=`1`
我已经正确地配置了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
我正尝试在我的PC上运行Snort,Windows7,每次我在命令提示符下运行它时都会收到这个错误,你对这个错误有什么想法吗??
ERROR: c:\Snort\etc\snort.conf(511) => Unable to open address file C:\Snort\rule
s\white_list.rules, Error: No such file or directory
Fatal Error, Quitting..
Could not create the registry key.
谢谢你。