Hallo,

Code:
create table tab2 as (select distinct * from tab1 where sp1 = 1) with data
lg Andreas