sql server与oracle查询最大值的区别

 

Sql server

sql1="select isnull(max(seq_no),0) as seq_no from bar_contrast"

 

Oracle

sql1="select nvl(max(seq_no),0) as seq_no from bar_contrast"