MySQL Forums
Forum List  »  IBM DB2

Select Max - from DB2 to Mysql
Posted by: Karthik Krishnamurthy
Date: March 22, 2006 10:47AM

Hi,
I am having the following syntax in my current application using DB2 and I need to move it to MySql. How would it translate in Mysql:

SELECT VALUE(MAX(INTEGER(SERVICE_LINE_NUMBER)),0) FROM SERVICE_INFO WHERE BATCH_ID = 1 AND PAGE_ID = 1


I tried Select Max(S_L_N).... but it returns null. If there is nothing I need it to return 1.

Please help.

Thx
Karthik

Options: ReplyQuote


Subject
Views
Written By
Posted
Select Max - from DB2 to Mysql
15706
March 22, 2006 10:47AM
4874
March 22, 2006 11:09AM
4020
March 24, 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.