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