作者decadance (世界尽头小酒馆)
看板Database
标题Re: [SQL]请问依照数量排序的语法
时间Tue Nov 18 22:44:55 2008
假设资料表叫做AAA
多到少
SELECT AAA.COLOR
FROM AAA
INNER JOIN
(SELECT COLOR,COUNT(*) AS NUMBER FROM AAA GROUP BY COLOR) AS TEMP
ON AAA.COLOR=TEMP.COLOR
ORDER BY TEMP.NUMBER DESC
少到多把DESC拿掉就好
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 61.216.7.217
1F：→ decadance:p.s.我是用MS sql写的 应该大同小异吧 11/18 22:46
2F：推 star508:感激不尽~ 11/18 22:48