Bisschen tricky aber sollte funktionieren.
BirgittaCode:Select x.PersNr, Count(*) from YourTable x Left Join YourTable y on x.PersNr = y.PersNr and x.ReiseVon = y.ReiseBis + 1 Day Where y.PersNr is NULL Group By x.PersNr
| ||||
Threaded View
Similar Threads
|
Bookmarks