select col1 from table order by col1;升序 select col1 from table order by col1 desc;降序
就是一个order by 语句。我补充一点,这是在pga中进行的,不是在sga中
嗯,可是在group by上出现了障碍,我想知道那些销量排行榜是怎么实现的
问题已解决select t1.photoname,t1.goodsname,(count(t2.goodsnum)) as c from goodsinfo t1 ,saletable t2 where t1.goodsname=t2.goodsname and t1.goodsprice=t2.goodsprice group by t1.goodsname,t2.goodsprice,t1.photoname order by c desc 这是正确的语句但我还不怎么理解
select col1 from table order by col1 desc;降序
as c from goodsinfo t1 ,saletable t2 where t1.goodsname=t2.goodsname and t1.goodsprice=t2.goodsprice
group by t1.goodsname,t2.goodsprice,t1.photoname order by c desc 这是正确的语句但我还不怎么理解