MySQL 8.0

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

create table mytable (
  ID	int,
  SignalName	varchar(20),
  Min	int,
  Max	int,
  Version int
);

insert into mytable values
(1,	'BrdgVltg',	0,	32000,	1),
(2,	'BattVltg',	0,	65000,	1),
(3,	'SigCurr',	0,	1000,	1),
(4,	'BattVltg',	0,	65000,	2),
(5,	'SigCurr',	0,	1000,	2),
(6,	'SigCurr',	0,	1000,	3);

Records: 6  Duplicates: 0  Warnings: 0


select *
from mytable


ID
SignalName
Min
Max
Version


1
BrdgVltg
0
32000
1

2
BattVltg
0
65000
1

3
SigCurr
0
1000
1

4
BattVltg
0
65000
2

5
SigCurr
0
1000
2

6
SigCurr
0
1000
3


select SignalName, MAX(Version) as max_version
from mytable
group by SignalName


SignalName
max_version


BrdgVltg
1

BattVltg
2

SigCurr
3


select t.*
from mytable t
inner join (
  select SignalName, MAX(Version) as max_version
  from mytable
  group by SignalName
) as s on s.SignalName = t.SignalName and s.max_version = t.version


ID
SignalName
Min
Max
Version


1
BrdgVltg
0
32000
1

4
BattVltg
0
65000
2

6
SigCurr
0
1000
3

ID	SignalName	Max	Version
1	BrdgVltg	32000	1
2	BattVltg	65000	1
3	SigCurr	1000	1
4	BattVltg	65000	2
5	SigCurr	1000	2
6	SigCurr	1000	3