收藏 不显示删除回复显示所有回复显示星级回复显示得分回复 如何根据点击次数排序[问题点数:50分，结帖人:wayne23]

SQL code

create table t_Product(proid int,proname varchar(10))

insert into t_Product values(1,'产品1')
insert into t_Product values(2,'产品2')
insert into t_Product values(3,'产品3')

create table t_Click(clickid int,proid int,clickrate int)
insert into t_Click values(1,1,57)
insert into t_Click values(2,2,22)
insert into t_Click values(3,3,110)


select a.* from t_Product a left join t_Click b on a.proid=b.proid order by b.clickrate desc

proid       proname
----------- ----------
3           产品3
1           产品1
2           产品2

(3 行受影响)

SQL code

select t_Product.proName ,t_Click.proID  from t_Click
left join t_Product on t_Product.proID=t_Click.proID
order by t_Click.clickRate desc

SQL code

select a.proID, a.proName, isnull(b.clickRate, 0) as clickRate
from t_Product a left join t_Click b on a.proID = b.proID
order by isnull(b.clickRate, 0) desc

SQL code

create table t_Product(proid int,proname varchar(10))

insert into t_Product values(1,'产品1')
insert into t_Product values(2,'产品2')
insert into t_Product values(3,'产品3')

create table t_Click(clickid int,proid int,clickrate int)
insert into t_Click values(1,1,57)
insert into t_Click values(2,2,22)
insert into t_Click values(3,3,110)

select m.* , n.* from t_Product m, t_Click n where m.proid = n.proid order by n.clickrate desc

drop table  t_Product , t_Click

/*
proid       proname    clickid     proid       clickrate   
----------- ---------- ----------- ----------- ----------- 
3           产品3        3           3           110
1           产品1        1           1           57
2           产品2        2           2           22

（所影响的行数为 3 行）
*/

得分回复需要阅读，请登录CSDN!