SQL Server 2014

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

create table reports (report_id int, report_created_by varchar(100), versions int, report_number int);
insert into reports (report_id, report_created_by, versions, report_number)
values (1, 'John Smith', 1, 101),
       (2, 'John Smith', 2, 101),
       (3, 'Jack Johson', null, null),  
       (4, 'Madeline Joe', null, null);
4 rows affected

select *
from ( select top(1) with ties
         report_id, report_created_by, versions, report_number
       from reports report_number
       order by dense_rank() over(partition by report_number
                                  order by versions) ) first_reports
order by report_id;


report_id
report_created_by
versions
report_number


1
John Smith
1
101

3
Jack Johson
null
null

4
Madeline Joe
null
null

report_id	report_created_by	versions	report_number
1	John Smith	1	101
3	Jack Johson	null	null
4	Madeline Joe	null	null