Oracle top 1 order by desc What not to do! Related articles. yyyy') ='06. g. 3. *, coalesce(ci. oracle数据库中order by的一些高级用法 现有一个表，表内容如下： 以下的操作都是对该表进行的操作 1. id order by ci. Leveraging Analytical Functions. So first we create a database. discountcode, 'na') as discountcode, row_number() over (partition by ci.