我需求是这样的.
表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