PHPstupid 发表于 2014-12-31 11:41

mysql子查询中排序不管用

      select DISTINCT c.created_date as account_effect_date,c.phone,c.employee_name
   fromt_employee_account a left join (select * from t_system_employee f order by f.employee_id DESC)c on a.employee_id=c.employee_id limit 0,15 ;

上面语句按ID排序,排序不起作用,请问是什么原因?
页: [1]
查看完整版本: mysql子查询中排序不管用