Need to truncate the present quarter data and reload only that quarter data without touch other records

Question

I need to delete the present quarter records but existing records can not be deleted.

In fiscal_quarter column FY23Q1/FY23Q2/FY23Q3/FY23Q4 are the values for that column Need help

insert into my_schema.my_table 
select * from my_schema.my_table 
where fiscal_quarter = 'FY%Q%'

Answer 1

Does the following do what you want?

delete from my_schema.my_table 
where fiscal_quarter = 'FY%Q%';