1.oracle和mysql使用group by的区别
假设有一张学生表(student)如图所示,我们要统计表中不同岁数人数
mysql:select count(age),* from student group by age
oracle:select count(age),age from student group by age
注意:MySQL可以返回整行,而Oracle只能返回group by有的字段,或者函数运算后的字段,因此Oracle在分组的时候会丢失rownum。
2.Oracle分页和MySQL分页的区别
对上面的表进行分页查询,查询第一条到第10条
mysql:select * from student limit 0,10 第一个参数表示偏移,第二个参数表示条数
oracle:select *from student where rownum>=0 and rownum<10
3.Oracle和MySQL分组后分页查询的区别
查询不同姓名的人数,并分页
mysql:select * from (select count(age),* from student group by name) limit 0,10
oracle:select * from (select *,rownum rn from(select count(name) from student group by name)) where rn>=0 and rn<10