谢谢crazy_boy1(小辉) 的回复! 我按照你的方法在phpMyAdmin中输入,提示我:Notice: Undefined offset: 0 in /usr/local/apache2/htdocs/phpMyAdmin/libraries/display_tbl.lib.php on line 462 Notice: Undefined offset: 0 in /usr/local/apache2/htdocs/phpMyAdmin/libraries/display_tbl.lib.php on line 698
select 姓名 sum(销售金额) as 销售金额 sum(其他金额) as 其他金额 count(姓名) as 结果 from A where 姓名='张三' or 姓名='李四'
我按照你的方法在phpMyAdmin中输入,提示我:Notice: Undefined offset: 0 in /usr/local/apache2/htdocs/phpMyAdmin/libraries/display_tbl.lib.php on line 462
Notice: Undefined offset: 0 in /usr/local/apache2/htdocs/phpMyAdmin/libraries/display_tbl.lib.php on line 698
sum(销售金额) as 销售金额
sum(其他金额) as 其他金额
count(姓名) as 结果
from A
where 姓名='张三' or 姓名='李四'