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? 

    Reply Like
Like Follow
  • 4 wk agoLast active
  • 1Replies
  • 7Views
  • 2 Following