mysql> select MIN(date) from t_c_effect_position_day;
出来的结果 是:
MIN(date)
20131013
这样的形式,字段名不再是date了 变成了MIN(date),这样不便于取date了。所以应该如下写
select MIN(date) as date from t_c_effect_position_day;
子查询
select id, name, sex (select addres from table_b where table_b.id=table_a.id) from table_a;