Select s_city From sort,
(Select s_id,Min(e_salary) as Min_salary From Emp group by s_id) T_temp
where T_temp.s_id=Sort.s_id and T_temp.Min_salary>1220 ;
(Select s_id,Min(e_salary) as Min_salary From Emp group by s_id) T_temp
where T_temp.s_id=Sort.s_id and T_temp.Min_salary>1220 ;
问题解决那 谢谢各位呀,特别是21ithorse(苏华)!