I have 1 table like the picture
I want to count column number the output as follows
I try but it not show column ID and name as I want.
select id, name, number, count(number) from table_demo group by id, name, number
Can’t help you with the SQL Server 2019
select id, name, number, count(*) over (partition by number) from table_demo order by 1,2
For future reading Microsoft Documentation and SQL Count Function with Partition By Clause