order by的字段中存在null 排序

1.SELECT * FROM table1  ORDER BY CASE WHEN Col Is NULL Then 1 Else 0 End, Col

2.SELECT * FROM table1 ORDER BY isnumeric(col) desc,col