Oracle 在select查询时有多条数据按原表内最大值+1进行显示

admin

1. SELECT t.*,
   
2.        MAX(original_column) OVER () + ROW_NUMBER() OVER (ORDER BY original_column) AS new_column
   
3. FROM your_table t
   
4. WHERE your_conditions;

复制代码

请将your_table替换为您的实际表名，original_column替换为您要基于其最大值加1的字段名，your_conditions替换为您的查询条件。

I can not participate now in discussion - there is no free time. I will return - I will necessarily express the opinion on this question.

A user-friendly mobile interface makes gaming on your phone smooth and enjoyable. Top casinos in 2025 feature intuitive menus, fast navigation, and touch-optimized games for seamless play. Look for platforms with responsive designs and easy access to support and payments. At secure-casinos.com, we’ve ranked the top 5 casinos with the best mobile interfaces. Ready for effortless mobile gaming? Explore our list and start playing today.  https://tinyurl.com/3cxurpma