database:copyrow

insert into myTable (col1,col2)
select * from tablex where Y > 1