-- Device status priority
-- ( 3 < 4) < 2 < 0 < 1

declare @tbl table (id int not null identity primary key, code int, dev int not null );

insert into @tbl values ( 3, 1 )
insert into @tbl values ( 3, 2 ), (4, 2)
insert into @tbl values ( 3, 3 ), (4, 3), (2, 3)
insert into @tbl values ( 4, 4 ), (2, 4), (0, 4)
insert into @tbl values ( 3, 5 ), (1, 5), (0, 5), (2, 5)

select * from @tbl

declare @result table (code int, dev int not null );

insert into @result values ( 3, 1 )
insert into @result values ( 4, 2 )
insert into @result values ( 2, 3 )
insert into @result values ( 0, 4 )
insert into @result values ( 1, 5 )

select * from @result