select calling_nbr,sum(balance)/100 from bill.prepay_php_call_ticket_08
where bureau_code_c4='MY' and (不知道如何写)end_time
group by calling_nbr;
注释：在bill.prepay_php_call_ticket_08表中，字段calling_nbr有很多相同的号码，每个号码我只要求取
当字段end_time下的值为这个号码的最大值时取该号码对应字段balancer的值!

select calling_nbr,sum(balance)/100 from bill.prepay_php_call_ticket_08
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)


---------------
Over 拉

select calling_nbr,sum(balance)/100 from 表
where bureau_code_c4='MY'
and
calling_nbr in (select calling_nbr,max(end_time) from 表 group by calling_nbr)

[此贴子已经被作者于2007-9-12 19:16:10编辑过]

晕要你要实现什么功能啊,最大值用max去试一下吗?