gorup by query issue i have one table, which has three fields and data.

Name , Top , total

cat , 1 ,10

dog , 2, 7

cat , 3 ,20

hourse 4, 4

cat, 5,10

Dog 6 9

i want to select record which has highest value of "total" for each Name

so my result should be like this.

Name , Top , total

cat , 3 , 20

hourse , 4 , 4

Dog , 6 , 9

i tried group by name order by total, but it give top most record of group by result.

any one can guide me , please!!!!