Forum Stats

  • 3,769,695 Users
  • 2,253,009 Discussions
  • 7,875,155 Comments

Discussions

Delete rows based on Filter condition

User_X9S6M
User_X9S6M Member Posts: 56 Red Ribbon

Expected Result:

My effort

DELETE FROM ETL.STG_DW_ACCT_GRP 

WHERE STG_DW_LOAD_DT >= '27-SEP-21'  

 AND ACCT_GRP_CD= '829' 

AND ACCT_GRP_NM = 'Z HEB'

AND ACCT_GRP_DESC='Z HEB'

Answers