¾«µäSQLÓï¾ä

·ÖÀàͳ¼Æ×ÜÊý²¢ÅÅÐò¶à±íÁªºÏ²éѯµÄÁ½ÖÖ·½·¨
Àý:
²éѯµØÇø±íÖи÷Ê¡ÏÂÃæ³ÇÊÐ×ÜÊý,²¢¶Ô²éѯ½á¹ûÈ¡Ç°Ê®Ãû
·¨Ò»:
select b.id,a.[name],b.counts from n_area a,(select top 10 parent_id as id,sum(parent_id) as counts from n_area where parent_id<>0 group by parent_id order by sum(parent_id) desc
) b where a.id=b.id
·¨¶þ:
select top 10 a.id,a.[name],(select count(*) from n_area b where b.parent_id=a.id ) as counts from n_area a where a.parent_id=0 order by counts desc
Àý:
²éѯ·¢Ìù±íÖлظ´Êý×î¶àµÄÇ°Ê®Ìõ·¢Ìù,(·¢ÌûÓë»ØÌûͬһ±í,²éѯ³ö·¢ÌûÖ÷Ìâ,·¢ÌûID,·¢ÌûÈË(Áí±í),»ØÌûÊý)
select a.mid,a.mtitle,(select c.uimg from BBS_Power c where c.uid=a.uid and c.uclass=a.uclass) as img from BBS_Msg a,(select top 10 partenID as id,sum(partenID) as counts from BBS_Msg  where partenID<>0 group by partenID order by sum(partenID) desc) b where a.mid=b.id