sql取各组中的最大值

<script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>

<script type="text/javascript"> </script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>

表test

id              name     record
1                a        88
2                b        76
3                c        66

4                c        90
5                b        77
6                a        56

7                b        77
8                c        67
9                a        44
获取abc...的最大记录数的id号
selecthh.id,hh.name,hh.recordfromtestashhwhere
hh.record=(selectmax(record)fromtest wherename=hh.name)
<script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>

<script type="text/javascript"> </script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>