oracle怎么查看字段最大值？

oracle sql查詢時查看字段最大值實現例句如下所示：

1、SELECT a.*

FROM table1 a WHERE NOT

EXISTS (SELECT 1 FROM table1 b WHERE b.id>a.id)

2、select * from table, (select name,max(value) value from table group by name) a where

table.name=a.name

and table.value=a.value