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.
Zähle alle, die noch älter sind. Und nehme nur diejenigen, bei denen der Zähler kleiner 2 ist (also 0 und 1)
select *
from t405578;
ID AGE
1 5
2 8
3 6
4 7
select
t.*,
(
select count(*)
from t405578 t1
where t1.age > t.age
) as count_older_items
from t405578 t;
ID AGE count_older_items
1 5 3
2 8 0
3 6 2
4 7 1
select
t.*
from t405578 t
where
(
select count(*)
from t405578 t1
where t1.age > t.age
) < 2;
ID AGE
2 8
4 7