Re: [SQL]請問依照數量排序的語法

[decadance (世界盡頭小酒館)]

假設資料表叫做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
→ decadance:p.s.我是用MS sql寫的 應該大同小異吧
推 star508:感激不盡~