safex
Reputation: 2514
Oracle SQL how to get rowmax?
I likely lack the correct vocabulary, which is why my google searches were unsuccessful to achieve the following rowmax type of operation: I want to create a new column that is for each row the maximum of two existing columns and is bounded by 0.
SELECT a,b, rowmax(a,b,0) as c
FROM ...
Upvotes: 0
Views: 109
Answers (1)
Related Questions
- Oracle SQL - Get max based on Column
- Finding max in Oracle
- How do I get the max record?
- oracle sql select maximum top x rows
- SQL: Find max number of rows
- How can I get the PK of the Max Row in SQL
- Get max number Oracle SQL
- Query to fetch row corresponding to Max value in SQL
- Sql select max from result column
- Sql Max() function on an rownum condition