求分类查询的一个sql
我需求是这样的.

表A:
字段
userid sex(性别)
1 1
2 2
3 1

表B
字段
userid rank(排名)
1 3
2 1
3 2



我想查的男女各第一名的userid.
sql 不好,求助大家

[解决办法]

SQL code

select top 1 useridfrom A inner join B on A.userid=B.useridwhere sex=1order by rankunion allselect top 1 useridfrom A inner join B on A.userid=B.useridwhere sex=2order by rank
[解决办法]

select userid from b
(
 select sex,min(rank) as rank from  
 (
 select * from a , b
 where a.userid=b.userid
 ) c
 group by sex
) d
where b.rank =d.rank