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 distinct t.name , t.alter from t405578 t
FROM t405578 t
WHERE
(
SELECT COUNT(*)
FROM t405578 t1
WHERE t1.age > t.age
) < 2
OR t.Alter in
( SELECT max(tmax.alter) as MaxAlter
FROM t405578 tmax
)
;
SELECT t.*
FROM t405578 t
WHERE
(
SELECT COUNT(*)
FROM t405578 t1
WHERE t1.age > t.age
) < 2;
-- Abfrage auswerten
ID AGE
2 8
4 7
-- Noch ein 8 Jähreiger hinzufügen und die Abfrage nochmals auswerten
insert into t405578(age) values(8);
ID AGE
2 8
7 8
-- Noch ein 8 Jähreiger hinzufügen und die Abfrage nochmals auswerten
insert into t405578(age) values(8);
ID AGE
2 8
7 8
8 8
SELECT t.*
FROM t405578 t
WHERE
(
SELECT COUNT(*)
FROM t405578 t1
WHERE t1.age > t.age
) < 2
and
( SELECT COUNT(*)
FROM t405578 t1
WHERE t1.age=t.age and t1.name<t.name
) <=1
;