查询每月得分

[maomao9414]

查询每月得分

其中有一个User表和一个积分表Score.

我要查出当月的前十名的姓名和所对应的积分

[别样苍茫]

join

[fwacky]

把数据，和想要的数据列出来，
无数据，无结果！

[yan267]

[Quote=引用 2 楼 fwacky 的回复:]
SQL code
把数据，和想要的数据列出来，
无数据，无结果！
[/Quote]

至少给个Score的表结构吧。

select Top 10 * from Score where  datediff(m,getdate(),ScorceTime)=0 order by  ScoreValue desc

[不懂装懂]

select top(10)*
from
(
select u.userName,s.score
from User u,Score s
where u.UserID=s.UserID
order by s.score
)as tab_1

[不懂装懂]

[Quote=引用 4 楼 fdh120 的回复:]
select top(10)*
from
(
select u.userName,s.score
from User u,Score s
where u.UserID=s.UserID
order by s.score
)as tab_1

[/Quote]
改order by s.score desc

[fuda_1985]

把积分的表结构弄出来。

[yzx314]

表结构都没有
！！

[mytimes_walker]

楼主没给表结构我就自己随便建了一个，实现如下：

create  table [User]
(
	[uid] int identity(1,1) primary key not null,
	[uname] varchar(10) not null
)
go
create table Score
(
	[uid] int not null foreign key references [User]([uid]),
	[score] int not null
)
go
insert into [User] values('张1')
insert into [User] values('张2')
insert into [User] values('张3')
insert into [User] values('张4')
insert into [User] values('张5')
insert into [User] values('张6')
insert into [User] values('张7')
insert into [User] values('张8')
insert into [User] values('张9')
insert into [User] values('张10')
insert into [User] values('张11')
go
insert into score values(1,18)
insert into score values(2,344)
insert into score values(3,45)
insert into score values(4,65)
insert into score values(5,85)
insert into score values(6,44)
insert into score values(7,30)
insert into score values(8,26)
insert into score values(9,77)
insert into score values(10,18)
insert into score values(11,8)
--前十名的姓名和所对应的积分 
select * from [User]
select * from [Score]

SELECT TOP 10 U.[uname],S.[Score] FROM [User] as U
INNER JOIN [Score] as S
ON U.uid = S.uid
ORDER BY S.[Score] DESC

[jenny0810]

结合3#和8#应该能得到你想要的结果

[hehuan1213]

select top(10)*
from
(
select u.userName,s.score
from User u,Score s
where u.UserID=s.UserID
order by s.score
)as tab_1