Csdn (Oracle) (Summary)

The database table contains three columns: ID name banben (Version) (the column value is a number ).
The ID is unique, the name is not unique, and the banben is not unique, but the combination of name and banben is unique. Find the ID of the row with the highest value of name = GIS and banben (version ).
Select ID, name, banben
From tablename a inner join (
Select max (banben) over (partition by name order by name) as maxbanben,
Rowid as RID
From tablename
Where name = 'gis'
) B on A. rowid = B. RID and A. sal = B. maxbanben