我正在嘗試獲取表格中字串的百分比，但我不知道如何在計數之后過濾字串而不是分割它。我嘗試了這個，因為我在網上找到了它，但它不起作用：
SELECT table.colum1, Count(table1.colum1) WHERE table1.colum1 LIKE "String" AS countString
FROM table1
GROUP BY table1.colum1 / (SELECT Count(table1.colum1) AS CountAll);
uj5u.com熱心網友回復：
了解如何做到這一點：
SELECT table1.colum1, Count(table1.colum1) / (SELECT Count(table.colum1) AS CountAll
FROM table1) AS PercentString FROM table1 WHERE table1.colum1 = 'String'
GROUP BY table1.colum1;
感謝您的幫助<3
轉載請註明出處，本文鏈接：https://www.uj5u.com/yidong/497872.html
上一篇：訪問錯誤運行時2447插入到表中