[SQL] Anzahl ältester Werte pro ID auslesen

[omata]

Warum so kompliziert?

SQL-Code:

SELECT id, article_id, user_id
FROM foo x
WHERE user_id = 1
GROUP BY article_id, id, user_id
HAVING id = (SELECT MIN(id) 
             FROM foo 
             WHERE article_id = x.article_id)
ORDER BY id

Und für alle User...

SQL-Code:

SELECT id, article_id, user_id
FROM foo x
GROUP BY article_id, id, user_id
HAVING id = (SELECT MIN(id) 
             FROM foo 
             WHERE article_id = x.article_id)
ORDER BY user_id, id

Und was meinst du mit der Anzahl? Vielleicht folgendes...

SQL-Code:

SELECT user_id, COUNT(*) AS anzahl
FROM (SELECT user_id
      FROM foo x
      GROUP BY id, user_id, article_id
      HAVING id = (SELECT MIN(id) 
                   FROM foo 
                   WHERE article_id = x.article_id)) x
GROUP BY user_id
ORDER BY user_id

Gruss
Thorsten