显示最新信息
create table EMAIL_STATUS_LAST as(
SELECT * from (SELECT * FROM EMAIL_STATUS WHERE time>'2019-03-01' ORDER BY time DESC) a GROUP BY a.id);
如果表存在:
insert into tab1 select * from tab2
如果表不存在:
create table tab1 as select * from tab2
显示最新信息
create table EMAIL_STATUS_LAST as(
SELECT * from (SELECT * FROM EMAIL_STATUS WHERE time>'2019-03-01' ORDER BY time DESC) a GROUP BY a.id);
如果表存在:
insert into tab1 select * from tab2
如果表不存在:
create table tab1 as select * from tab2