如何查找SQL数据库中每一笔数据的第一笔记录

SELECT * FROM ABC W WHERE Creatdatetime=(SELECT min(Creatdatetime) FROM ABC WHERE ID=W.ID AND RESULT=W.RESULT)