Your Ad Here

advanced code snippet search

Posted By

wesleymacente on 07/21/11


Tagged


Versions (?)

DELETA DUPLI

 / Published in: PHP
 
Expand | Embed | Plain Text 
  1. $deletadupli = "DELETE FROM seminovos WHERE id in (SELECT id FROM (SELECT id, ficha, COUNT(*) quant
  2. FROM seminovos
  3. GROUP BY ficha
  4. HAVING quant > 1) t )";
  5. $deldupli =  query($deletadupli);

Report this snippet  

You need to login to post a comment.