摘要:
sql语句根据特定条件改变排序及效率测试两个解决方案:SELECT * FROM T_AdminORDER BY CASE WHEN admin_name = 'loo' THEN 0 ELSE 1 END另外一种:SELECT *, 0 AS tmp_oFROM t_adminWHERE admin_name = 'loo'UNIONSELECT *, 1 AS tmp_oFROM t_adminWHERE admin_name <> 'loo'ORDER BY tmp_o现在来考虑一下两条语句的效率问题建立表: CREATE TA 阅读全文
posted @ 2007-10-04 11:32
路大侠
阅读(147)
评论(0)
推荐(0)

浙公网安备 33010602011771号