SQL语句高手进来看一下，谢谢

[athrun0814]

select test_id,test_celltext,test_type,test_ttime from ydyed_com_f.GE_TestList where test_state=1 order by test_ttime desc

我要查找出test_celltext和test_type不重复的记录，怎么改？

[alibabademama]

友情 up













----------------------完美的签名线----------------------------
网页游戏开发第一站 http://dev.web863.com

[hcbzd]

select test_id,test_celltext,test_type,test_ttime 
from ydyed_com_f.GE_TestList 
where test_state=1 
GROUP BY test_celltext,test_type
order by test_ttime desc