SELECT a.CODE,a.PK_MATERIAL from bd_material b,(SELECT CODE,max(CREATIONTIME) as time from bd_material GROUP BY CODE ORDER BY COUNT(*) DESC )a where b.CODE=a.CODE and b.CREATIONTIME=a.time |
最佳回答 |
||||
0
|
|