SQL Befehl: erster und letzter Datensatz

[omata]

Das geht auch schicker...

SQL-Code:

SELECT *
FROM tab_users u
INNER JOIN tab_values v
  ON u.uid = v.uid
WHERE statetime BETWEEN :anfang AND :ende
  AND (    statetime = (SELECT MIN(statetime)
                        FROM tab_values
                        WHERE uid = u.uid
                          AND statetime BETWEEN :anfang AND :ende)
        OR statetime = (SELECT MAX(statetime)
                        FROM tab_values
                        WHERE uid = u.uid
                          AND statetime BETWEEN :anfang AND :ende))