Copy Table(DDL)

 
create table agents_copy as select * from agents;

select * from agents_copy;

===========================================================================

create table agents_copy2 as select * from agents_copy;

insert into agents_copy2 select * from agents_copy;

===========================================================================

drop table if exists agents_copy3;

create table if not exists agents_copy3 like agents_copy2 ;

insert into agents_copy3 partition(part_col) select * from agents_copy2 ;

===========================================================================

select * into agents_copy4  from agents_copy2;

or

select * into agents_copy4 from agents_copy2 where salary>2000;

===========================================================================