select
id,s.sid,(select total_aver_score from car_comment_score where sid = tb2.sid) as '评分总数',supports,series
from
(
select
id,sid,supports,row_number() over (partition by sid order by id desc) as row_id2
from car_comment as comm
) as tb2
inner join car_series as s on tb2.sid = s.sid
where row_id2 = 1 and MinPrice >=0 and MaxPrice <= 550000
order by id descselect top 7 * from car_commentid sid 评分总数 supports series 系列总数
45 434 51 0 新威驰 18
40 188 92 0 昌河海象 69
37 163 65 0 吉普之星 50
系列总数是我自己加上的...
如:新威驰总共有18个、昌河海象69个
id,s.sid,(select total_aver_score from car_comment_score where sid = tb2.sid) as '评分总数',supports,series
from
(
select
id,sid,supports,row_number() over (partition by sid order by id desc) as row_id2
from car_comment as comm
) as tb2
inner join car_series as s on tb2.sid = s.sid
where row_id2 = 1 and MinPrice >=0 and MaxPrice <= 550000
order by id descselect top 7 * from car_commentid sid 评分总数 supports series 系列总数
45 434 51 0 新威驰 18
40 188 92 0 昌河海象 69
37 163 65 0 吉普之星 50
系列总数是我自己加上的...
如:新威驰总共有18个、昌河海象69个
解决方案 »
- 请教一select排序的问题,望高手指点,谢!
- 关于substring()函数
- 询问一个SQL语句是否有更好的写法!
- 急!截去字符串并转换为数字类型!谢谢!!!
- msde问题
- 在Windows server 2003 上装完sql 2000,打sp3补丁,无效,何解?
- 再次求教!!
- SQL Server备份问题总结
- 看看这段Select语句是什么意识 left outer join dbo.tablename b on a.feild3=b.feild3 and a.feildn=
- 紧急求救:在VC++里如何通过ATL OLE DB访问(INSERT\UPDATE\DELETE\SELECT)ORACLE和SQL SERVER里的BLOB字段内容?
- 最SQL
- SQL表类型修改
id,s.sid,(select total_aver_score from car_comment_score where sid = tb2.sid) as '评分总数',supports,series,系列总数=COUNT(1)OVER(PARTITION BY s.sid)
from
(
select
id,sid,supports,row_number() over (partition by sid order by id desc) as row_id2
from car_comment as comm
) as tb2
inner join car_series as s on tb2.sid = s.sid
where row_id2 = 1 and MinPrice >=0 and MaxPrice <= 550000
order by id desc?
id,s.sid,(select total_aver_score from car_comment_score where sid = tb2.sid) as '评分总数',supports,series,系列总数=COUNT(1)OVER()
from
(
select
id,sid,supports,row_number() over (partition by sid order by id desc) as row_id2
from car_comment as comm
) as tb2
inner join car_series as s on tb2.sid = s.sid
where row_id2 = 1 and MinPrice >=0 and MaxPrice <= 550000
order by id desc??