oracel 数据库按已知数据的id排序,把已知数据放在最前面
select *
from fai_technician
order by case
when id = '201705270915260005010327152301984dbd80b8' then
0
else
1
end asc,
id asc
select *
from fai_technician
order by case
when id = '201705270915260005010327152301984dbd80b8' then
0
else
1
end asc,
id asc