【mysql 和oracle】

目录

时间函数差异

分组排序差异

---

时间函数差异

mysql

select TIMESTAMPDIFF(DAY,'2023-01-01 00:00:00','2023-02-02 00:00:00') from dual

oracle

select CEIL(B.OCCUR_TIME - A.RPT_TIME ) from dual

分组排序差异

mysql

set @rank:=0;

select *,

@rank:=case when @current_id<>departno then 1 else @rank+1 end as rank,

@current_id:=departno from testa

order by departno,num desc

oracle

select row_number() over(partition by departno ORDER BY num DESC) as hsal

from testa