访问SQL如下: SELECT *FROM ( SELECT TNAME,COUNT(1) NUMB,MAX(LOGTIME)LASTTIME FROM PUBLIC.FR_EXERECORD WHERE LOGTIME>='${dateEditor0}' AND LOGTIME<='${dateEditor1}' GROUP BY TNAME )ORDER BY NUMB DESC |
最佳回答 |
||||
0
|
|