摘要:
mySQL数据库: SELECT id_p,IFNULL(math,0)+IFNULL(english,0) 总分 from mytest_brian1 Oracle 数据库: select id_p , nvl(address,0)* age from Persons2 ; NVL( string 阅读全文
摘要:
oracle 的分页查询: select * from (select o.*,rownum rn from Persons o) where rn >40 and rn <=60 ; mySQL 的分页查询: select o.* from Persons o limit 40,20 ; limi 阅读全文