SQL Server 2022

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

create table mytable (
  [Insert Date] date,
  [Value1] int,
  [Value2] int,
  [Group] varchar(10)
);

insert into mytable values
('2023-01-01',	123,	135,	'a'),
('2023-02-01',	234,	246,	'a'),
('2023-01-02',	456,	468,	'b'),
('2023-02-02',	345,	357,	'b');
4 rows affected

with grt as (
  select *, GREATEST([Value1], [Value2]) as GREATEST
  from mytable
),
max_grt as (
  select [Group], max(GREATEST) as max_GREATEST
  from grt
  group by [Group]
),
cte as (
  select g.*
  from max_grt as mg
  inner join grt as g on g.GREATEST = mg.max_GREATEST
)
select min([Insert Date])
from cte


(No column name)


2023-01-02