select DISTINCT c.created_date as account_effect_date,c.phone,c.employee_name
from t_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排序,此语句不管用,要怎么写?
from t_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排序,此语句不管用,要怎么写?
from t_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 order by c.employee_id desc limit 0,15 ;
子查询中的排序对整个结果并无意义。
--
select DISTINCT c.created_date as account_effect_date,c.phone,c.employee_name
from t_employee_account a left join (select * from t_system_employee f ) c on a.employee_id=c.employee_id
order by a.employee_id DESC limit 0,15 ;