Follow along with the video below to see how to install our site as a web app on your home screen.
Anmerkung: This feature currently requires accessing the site using the built-in Safari browser.
SELECT
`a`.*
FROM
`Tabelle` AS `a`
INNER JOIN
`Tabelle` AS `b` USING (`VeranstaltundID`)
WHERE
`a`.`id` != `b`.`id` -- Datensätze dürfen nicht identisch sein
AND ABS(`a`.`foobar` - `b`.`foobar`) <= 50
SELECT a.Id, a.veranstaltungsID, a.Asche, b.asche, Abs(a.asche -b.asche) as Diff
FROM
Tabelle a, tabelle b
WHERE a.id <> b.id
AND a.veranstaltungsID = b.VeranstaltungsID
And Abs( a.Asche - b.Asche) <= 50
Order by Id;