作者cy0824 (chuchutrainz)
看板Web_Design
标题[问题] mysql count/count 怎麽做??
时间Fri Nov 10 05:15:12 2006
请问一下,我有两个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