SQLite 3.39

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table t (fn varchar(10), ln varchar(10));
✓
insert into t (fn, ln)
values ('john','frost'), ('jack','wayne'),('betty','white'),(null,'jackson');
✓
select fn, count(fn) from t;


fn
count(fn)


john
3


select fn, count(fn) over () from t;


fn
count(fn) over ()


john
3

jack
3

betty
3

null
3