Çë½ÌÒ»¸ösqlÓï¾äµÄд·¨

ÐÂÎűínews id,c_id,tim,topic

ÆÀÂÛ±í review rid,rsort,re_id

ÐÂÎűíÐèÒª¸ù¾Ý ÆÀÂÛÊýÀ´ÅÅÐò £¬Á½±íµÄÁ¬½ÓÌõ¼þÊÇ news.id=review.re_id


ÕâsqlÓï¾äÒªÔõôдÄØ

---

SQL code:
SELECT * from news AS A
ORDER BY ISNULL((SELECT COUNT(*) from reveiw
WHERE A.id = re_id),0) DESC;

---

¸ø³öÊý¾Ý°É£¡

---

SQL code:
select n.id,n.c_id,n.tim,n.topic,r.rid,r.rsort,r.re_id

from news n inner join review r on n.id=r.re_id order by r.rsort desc

---

SQL code:
select a.* from news a left join review b on a.id=b.re_id order by b.ÆÀÂÛÊý×Ö¶Î

---

SQL code:

select a.* from news a
left join(
select re_id ,num=count(*) from review group by re_id
)b on a.id=b.re_id
order by num desc

---

SQL code:

select news.id,news.c_id,news.topic,R.ÆÀÂÛÊý
from news
left join
(select re_id,count(*) as ÆÀÂÛÊý
from review
group