查询每个账号关联的旅客数量，手机尾号为8的 - SQL语句示例
SELECT username, COUNT(*) AS count FROM passenger WHERE RIGHT(cardnum, 1) = '8' GROUP BY username ORDER BY count DESC;
原文地址: https://www.cveoy.top/t/topic/pRiD 著作权归作者所有。请勿转载和采集!
安全问答是一个知识全球问答,包含丰富的问答知识
SELECT username, COUNT(*) AS count FROM passenger WHERE RIGHT(cardnum, 1) = '8' GROUP BY username ORDER BY count DESC;
原文地址: https://www.cveoy.top/t/topic/pRiD 著作权归作者所有。请勿转载和采集!