title: Truncate with condition
body: <p>truncate  ->this resets the entire table, is there a way via truncate to reset particular records/check conditions.</p>
  
  <p>For ex: i want to reset all the data and keep last 30 days inside the table.</p>
  
  <p>Thanks.</p>