MySQL Forums
Forum List  »  IBM DB2

Re: Select Max - from DB2 to Mysql
Posted by: Kenneth Moses
Date: April 26, 2006 02:15PM

Please try
IFNULL(MAX(S_L_N),1) which returns the max if it exists and 1 otherwise

Options: ReplyQuote


Subject
Views
Written By
Posted
4772
March 22, 2006 11:09AM
3921
March 24, 2006 02:15PM
Re: Select Max - from DB2 to Mysql
5525
April 26, 2006 02:15PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.