关于如何提取最大值？

[jieru1986]

我现在有一个选票系统，我想提取每一个被选项目的最大票数，应该怎么写SQL语句啊？

[linda_gao]

select max(ddd) from table where aa=222;

[hyf_0023]

select max(ddd) into : ls_ss from table where aa=222;

[yl_yz]

select aa,max(ddd) from table group by aa order by aa