Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 1 of 1
08-02-2012, 07:04 PM #1
- Join Date
- Apr 2012
- St. Louis, MO
- Thanked 101 Times in 101 Posts
ORACLE: Can COALESCE() be nested inside MAX()?
In Oracle (10g and 11g), can COALESCE() be nested inside MAX()?
For example, I want to get the current MAX value of a column used for sort order of records (ie, 1,2,3,4..) for a particular application listing; going to add one to it and use it for the next entry for that app. So I was usingCode:
SELECT MAX(sort_order)+1 FROM table WHERE app_id = 'F8'
SELECT MAX(COALESCE(sort_order,0))+1 FROM table WHERE app_id = 'F8'
Last edited by WolfShade; 08-03-2012 at 07:18 PM.^_^
If anyone knows of a website that can offer ColdFusion help that isn't controlled by neurotic, pedantic jerks* (stackoverflow.com), please PM me with a link.
* The neurotic, pedantic jerks are not the owners; just the people who are in control of the "popularity contest".