cobi_xiao 发表于 2007-9-11 07:25
急，请教一个问题？？
select calling_nbr,sum(<FONT color=#000000>balance</FONT>)/100 from bill.prepay_php_call_ticket_08 <BR>where bureau_code_c4='MY' and (不知道如何写)<FONT color=#000000>end_time</FONT> <BR>group by calling_nbr;<BR>注释：在bill.prepay_php_call_ticket_08表中，字段calling_nbr有很多相同的号码，每个号码我只要求取<BR>当字段end_time下的值为这个号码的最大值时取该号码对应字段balancer的值!
gugu0792 发表于 2007-9-12 18:57
select calling_nbr,sum(balance)/100 from bill.prepay_php_call_ticket_08 <BR> where bureau_code_c4='MY' and calling_nbr in (select calling_nbr,sum(end_time) from bill.prepay_php_call_ticket_08 group by calling_nbr)<BR><BR><BR>---------------<BR>Over 拉
西风独自凉 发表于 2007-9-12 19:09
select calling_nbr,sum(balance)/100 from 表<br> where bureau_code_c4='MY' <br>and <br> calling_nbr in (select calling_nbr,max(end_time) from 表 group by calling_nbr)<br><br>
[align=right][color=#000066][此贴子已经被作者于2007-9-12 19:16:10编辑过][/color][/align]
tangchangxin 发表于 2007-9-17 23:08
<P>晕要你要实现什么功能啊,最大值用max去试一下吗?</P>
页:
[1]
