请大家帮忙看看，谢谢！

[betagain]

SELECT DISTINCT SPEC_TYPE FROM M_SPEC WHERE BORYUMU_ID2 ORDER BY SPEC_AUTOID DESC

提示distinct 不能和 order by 一起用，请问如何改写啊？

谢谢了！！！！

[Navywang917]

SELECT DISTINCT SPEC_TYPE，SPEC_AUTOID FROM M_SPEC WHERE BORYUMU_ID2 ORDER BY SPEC_AUTOID DESC

[betagain]

上面的，得到的结果不对，SPEC_TYPE没有distinct

[hsj20041004]

你的语句错了！！
SELECT DISTINCT SPEC_TYPE FROM M_SPEC ORDER BY SPEC_AUTOID DESC

[hsj20041004]

你的语句错了！！
SELECT DISTINCT SPEC_TYPE FROM M_SPEC ORDER BY SPEC_TYPE DESC

[hsj20041004]

SELECT DISTINCT SPEC_TYPE，SPEC_AUTOID FROM M_SPEC ORDER BY SPEC_AUTOID DESC

[betagain]

上面的答案都不行
我想要：
按照SPEC_AUTOID的降序，并且SPEC_TYPE不相同的

[betagain]

我写错了，原句是这样的
SELECT DISTINCT SPEC_TYPE FROM M_SPEC WHERE BORYUMU_ID=2 ORDER BY SPEC_AUTOID DESC

[chenqianlong]

給出要的結果，及表的幾條記錄

[betagain]

表：M_SPEC
字段： SPEC_AUTOID SPEC_TYPE
1 a
2 a
3 b
4 b
5 c
6 c

希望得到结果： SPEC_TYPE
c
b
a

[yesyesyes]

select spec_type
from m_spec group by spec_type
order by min(spec_autoid) desc