×îSQL - MS-SQL Server / »ù´¡Àà

SQL code:

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 desc

ÏÖÖ´ÐÐÈçÉÏSQLµÃµ½ÈçϵÄÊý¾Ý£¬ÒâΪ²»Í¬ÏµÁеÄijһÌõÊý¾Ý£¬ÈôÏÖÔÚÏëµÃµ½Ã¿¸öϵÁÐϵÄ×ܸöÊý¸ÃÔõôŪÄØ¡£¡£¡£ÈçϵÁÐÐÂÍþ³ÛÓÐ88¸ö¡¢²ýºÓº£ÏóÓÐ35¸ö

---

£¿£¿¿ì³ÁÁË

---

ÒýÓÃ

select
id,s.sid,
(select total_aver_score from car_comment_score where sid = tb2.sid) as '×ÜÆÀ·Ö',
supports,series, count(series) AS seriesNum
from
(
select
id,sid,supports,row_number() ove¡­¡­

»¹ÊÇû¿´µ½ÎÒÒªµÄ½á¹û¡£¡£¡£

---

SQL code:
select
id,s.sid,
(select total_aver_score from car_comment_score where sid = tb2.sid) as '×ÜÆÀ·Ö',
supports,series,count(1)over(partition by series) as ×ܸöÊý
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