MSSQL
select *
from a
order by datediff(dd,isnull(u,t),getdate())
MYSQLselect *
from a
order by datediff(isnull(u,t),now())
如上红色部分,有办法实现吗
select *
from a
order by datediff(dd,isnull(u,t),getdate())
MYSQLselect *
from a
order by datediff(isnull(u,t),now())
如上红色部分,有办法实现吗
order by IFNULL(u,t)