修改null值在排序中的位置方法
MySQL:
select * from user u order by u.orderid is null, u.orderid
PostgreSQL:
SELECT * from printers order by sw_version DESC NULLS FIRST;
修改null值在排序中的位置方法
MySQL:
select * from user u order by u.orderid is null, u.orderid
PostgreSQL:
SELECT * from printers order by sw_version DESC NULLS FIRST;