/* 分组排序取第一条数据*/
SELECT *
FROM (SELECT ROW_NUMBER() OVER(PARTITION BY taskbreakid ORDER BY responsedate DESC) LEV, r.*
-- select r.*
FROM tablename r
WHERE LEV = 1
/*
--ORDER BY responsedate DESC
taskbreakid ---> 分组列
responsedate ---> 分组中排序列
tablename ---> 表名
*/
/* 取第一条数据 */
select * from ( select * from tablename t order by paisulie ) where rownum = 1