sql运行出现错误:Every derived table must have its own alias
select a,max(strt_req_time) from(
select a ,star_time,end_time,jhpt_update_time from logmonitor.gp_interface_call_record_city where a like ‘XQ+_%‘escape’+’
)
group by a
sql中生成一个新表必须要指定表名,在后面增加一个as a即可运行