Thursday, April 23, 2015

DB2 SQL select CASE

select CASE when max(id) is  null then 1 else max(id) + 1 end from  mytable

No comments:

Post a Comment