SQL Server 2017

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

create table test (id int)
insert into test  values (1), (2), (3), (4)
4 rows affected

with cte as (select * from test where id < 4)
select top 2 *, count(*) over () total_count
from cte
order by id desc


id
total_count


3
3

2
3