加盟卫浴什么牌子好:sql查询，投票的数据库中如何统计票数并排名呢？

楼上的语句没有毛病，不过搂主提供了userinfo表，这里如果某个用户没有得票的话，就统计不上了，还是join一把比较好点。另外直接查询的话结果体现不出来名次
select identity(int,1,1) as [名次],a.username as [用户名],count(*) as [票数]
into #temporders
from userinfo a left join votes b
on a.username=b.username
group by a.username
order by [票数] desc

select *
from #temporders
order by [名次]

用外连接实现，如下：
create table person
(perno varchar(8) not null)

create table temp
(perno varchar(8) not null,
cou integer not null
)

insert into person
select 'A '
union
select 'B'
union
select 'C'
union
select 'D'

insert into temp
select 'A',1
union all
select 'A',1
union
select 'B',1
union
select 'C',1

select * from temp
select a.perno,COUNT(b.perno)as '票数' from person a left join temp b on a.perno = b.perno
group by a.perno;
显示结果连包括0票的人员都会统计出来。

用count以及rank等分析函数

select username,count(*) from votes group by username order by count(*) desc