流量卡 sql 记录

SELECT ICCID,gatewaySN,gatewayName,project,operator,setMeal,surplusFlow,serviceFlow,expireTime,activateTime,projectPrincipal FROM simOrm WHERE activateTime < 1704038400000 AND activateTime > 1 AND simManufacturer = 2 AND operator = '移动' AND setMeal LIKE '%2G%' AND serviceFlow > 100
SELECT project,COUNT(projectID) FROM simOrm WHERE activateTime < 1704038400000 AND activateTime > 1 AND simManufacturer = 2 AND operator = '移动' AND setMeal LIKE '%2G%' GROUP BY project

“您的支持是我持续分享的动力”

微信收款码
微信
支付宝收款码
支付宝

黄金_shmaur
不积跬步,无以至千里;不积小流,无以成江海
目录关闭