简单的 sql 查询问题，求教

[xuyl]

表如下：

score

id | name | sex | score|

1 | tony | man | 80 |

2 | lily | woman | 90 |

---

3 | lucy | woman | 85 |

---

4 | andy | man | 95 |

---

要查出man和woman的最高分，如下

---

sex | name | score |

---

man | andy | 95 |

---

woman | lily | 90 |

---

select 语句怎么写？
我是菜鸟，只会写这样 select sex,max(score) as score from score group by score; 能否不用子查询就把name也查出来？

[bigfella]

@bin456789 摁~ 没想到， 改了下， 加了性别的条件，应该差不错吧
select * from (select t.sex, max(t.score) as score from score t group by sex) aa, score bb where bb.sex = aa.sex and bb.score = aa.score