[問題] mysql count/count 怎麼做??
請問一下,我有兩個queries
Table:A
field:a,b,c
$query1= "SELECT a, count(b) from A where a='$a' group by a";
$query2= "select a, count(b) from A where a='$a' and c='1' group by a";
我想有一個新的query是query2 除以 query1然後取百分比..然後四捨五入,,請問怎麼做呢??
謝謝
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 58.105.142.171
討論串 (同標題文章)