Code :
SET @pos1 =0; SET @pos2 =0; SELECT TmpP2.article AS ValeurArticle FROM (SELECT (@pos1 := @pos1 + 1) AS NumLigne, p1.id, p1.article FROM Produits p1 ORDER BY p1.id) AS TmpP1 INNER JOIN (SELECT (@pos2 := @pos2 + 1) AS NumLigne, p2.id, p2.article FROM Produits p2 ORDER BY p2.id) AS TmpP2 ON (TmpP2.NumLigne = (TmpP1.NumLigne - 1)) WHERE TmpP1.article <> TmpP2.article UNION ALL SELECT TmpP3.article AS ValeurArticle FROM (SELECT 1 AS NLigne, p3.id, p3.article FROM Produits p3 ORDER BY p3.id DESC LIMIT 0, 1) AS TmpP3 INNER JOIN (SELECT 1 AS NLigne, p4.id, p4.article FROM Produits p4 ORDER BY p4.id DESC LIMIT 1, 1) AS TmpP4 ON (TmpP3.NLigne = TmpP4.NLigne) WHERE TmpP3.article <> TmpP4.article
|