SQL Befehl: erster und letzter Datensatz

[mkinzler]

Eine Union könnte auch helfen

SQL-Code:

  select 
    * 
  from 
    tab_values where statetime>=$anfang and statetime <=$ende 
  group by 
    uid
  order by 
    starttime asc limit 1
union
  select 
    * 
  from 
    tab_values where statetime>=$anfang and statetime <=$ende 
    group by 
    uid
  order by 
    starttime desc limit 1;