Advertisement
Evra70

a

Dec 9th, 2021
1,109
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. begin;
  2.  
  3. CREATE TABLE fi_vat_out_for_efaktur_20211209 AS
  4. (
  5.     select * from fi_vat_out_for_efaktur
  6.     where tenant_id = 10
  7.     AND tax_no = '010.007-21.40684275'
  8. );
  9.  
  10. DELETE FROM fi_vat_out_for_efaktur
  11. where tenant_id = 10
  12. AND tax_no = '010.007-21.40684275';
  13.  
  14. select * from fi_vat_out_for_efaktur_20211209;
  15.  
  16. --rollback
  17.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement