DataBase

1.mongodbに接続
/usr/local/mongodb-3.0.4/bin/mongo 172.17.2.10:30000/admin

2.shardを追加
db.runCommand({̶ ...

DataBase

SQL構文
SELECT SUM(CASE WHEN ID >=21 THEN 1 ELSE 0 END ) AS ‘COLA’,
SUM(CASE WHEN ID <=20 THE ...

DataBase

例1
SELECT COUNT(DISTINCT CASE
WHEN addId >= 202 AND addId <= 258
THEN addId2 END)
FROM t_addres ...