SQL Server 2017

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

create table myTable ([Code] varchar(20),[Type] int)
insert into myTable
values
('U1',0)
,('U1',0)
,('U1',1)
3 rows affected

create view MyView 
as
select *
    ,Line_No = row_number() over (partition by [Code], [Type] order by (select null)) 
from myTable
select * from myView


Code
Type
Line_No


U1
0
1

U1
0
2

U1
1
1