1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44
| SELECT a.ID, a.AdrIP, b.AdrIP, c.AdrIP
FROM T AS a
, T AS b
, T AS c
WHERE a.ID = b.ID
AND a.ID = c.ID
AND a.AdrIP < b.AdrIP
AND b.AdrIP < c.AdrIP
UNION
SELECT a.ID, a.AdrIP, b.AdrIP, '--'
FROM T AS a
, T AS b
WHERE a.ID = b.ID
AND a.AdrIP < b.AdrIP
AND NOT EXISTS (SELECT *
FROM T AS c
, T AS d
, T AS e
WHERE a.ID = c.ID
AND c.ID = d.ID
AND d.ID = e.ID
AND c.AdrIP < d.AdrIP
AND d.AdrIP < e.AdrIP
)
UNION
SELECT a.ID, a.AdrIP, '--', '--'
FROM T AS a
WHERE NOT EXISTS (SELECT *
FROM T AS b
, T AS c
WHERE a.ID = b.ID
AND b.ID = c.ID
AND b.AdrIP < c.AdrIP
)
AND NOT EXISTS (SELECT *
FROM T AS d
, T AS e
, T AS f
WHERE a.ID = d.ID
AND d.ID = e.ID
AND e.ID = f.ID
AND d.AdrIP < e.AdrIP
AND e.AdrIP < f.AdrIP
) ; |
Partager