SELECT author, numb FROM (SELECT author, COUNT(*) AS numb FROM ping WHERE (RoomId IS NOT NULL) AND (tim > '2007-4-1') AND (LEN(body) > 30) GROUP BY author) DERIVEDTBL WHERE (numb >= 5) ORDER BY numb DESC上面程序正确的我现在不想按numb排序,想按时间排序,怎么写,写了几个小时没有写出来,想请高手帮忙.. 时间是按tim这个排的.
谢谢大家
谢谢大家
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货