Not able to delete rows in sql definition

i am trying this query in sql definition in mode analytics 

"delete from <table_name> where <date_filter>" ... but the result is showing as "NO ROWS RETURNED"...means rows are not deleting ...what is the proper method in mode sql analytics to delete rows from a table...

1reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Hey there, Sahill! Thanks for reaching out to us. 


    I would suggest using something like this, 

    DELETE FROM table_name WHERE condition;


    In your above example, are you setting that condition equal to some value? 

Like Follow
  • 6 mths agoLast active
  • 1Replies
  • 12Views
  • 2 Following