select t.* from (
select top 1 u.id,u.uid,f.head,f.sex,f.postnum from userinfo u,fm_userinfo f where u.id=f.userid and f.sex='男' order by f.postnum desc
union all
select top 1 u.id,u.uid,f.head,f.sex,f.postnum from userinfo u,fm_userinfo f where u.id=f.userid and f.sex='女' order by f.postnum desc
) t
order by t.id desc
select top 1 u.id,u.uid,f.head,f.sex,f.postnum from userinfo u,fm_userinfo f where u.id=f.userid and f.sex='男' order by f.postnum desc
union all
select top 1 u.id,u.uid,f.head,f.sex,f.postnum from userinfo u,fm_userinfo f where u.id=f.userid and f.sex='女' order by f.postnum desc
) t
order by t.id desc
select top 1 u.id,u.uid,f.head,f.sex from userinfo u,fm_userinfo f where u.id=f.userid and f.sex='男'
union all
select top 1 u.id,u.uid,f.head,f.sex from userinfo u,fm_userinfo f where u.id=f.userid and f.sex='女' order by f.postnum desc