Admin Liste des fraudes: Fraude de facturation `SELECT * FROM FACTURE AS f1 JOIN (SELECT * FROM FACTURE) AS f2 USING (ID_ARTICLE) WHERE f1.PRIX>f2.PRIX` @Admin
Admin Une autre suggestion plus précise: `SELECT * FROM FACTURE AS f1 JOIN (SELECT * FROM FACTURE) AS f2 USING (ID_ARTICLE) WHERE f1.PRIX>f2.PRIX GROUP BY BRANCHE HAVING BRANCHE=0`
user Une autre suggestion : SELECT * FROM FACTURE AS f1 JOIN (SELECT * FROM FACTURE) AS f2 USING (ID_ARTICLE) WHERE f1.PRIX>f2.PRIX GROUP BY ID_BRANCHE
user @user SELECT * FROM FACTURE AS f1 JOIN (SELECT * FROM FACTURE) AS f2 USING (ID_ARTICLE) WHERE f1.PRIX>f2.PRIX GROUP BY BRANCHE
user Une autre suggestion plus simple : SELECT * FROM FACTURE AS f1 JOIN (SELECT * FROM FACTURE) AS f2 USING (ID_ARTICLE) WHERE f1.PRIX>f2.PRIX
Admin user `SELECT * FROM FACTURE AS f1 JOIN (SELECT * FROM FACTURE) AS f2 USING (ID_ARTICLE) WHERE f1.PRIX>f2.PRIX GROUP BY BRANCHE`
user Une autre suggestion plus simple : SELECT * FROM FACTURE AS f1 JOIN (SELECT * FROM FACTURE) AS f2 USING (ID_ARTICLE) WHERE f1.PRIX>f2.PRIX
user [unknown] SELECT * FROM FACTURE AS f1 JOIN (SELECT * FROM FACTURE) AS f2 USING (ID_ARTICLE) WHERE f1.PRIX>f2.PRIX
user hello SELECT * FROM FACTURE AS f1 JOIN (SELECT * FROM FACTURE) AS f2 USING (ID_ARTICLE) WHERE f1.PRIX>f2.PRIX
