oracle分组取最大、最小

==========oracle分组取最大、最小============
select id,date
  from (select t.id,t.date,
               row_number() over(partition by t.id order by t.date asc) rn
          from tab t
        )
 where rn = 1;