MySQL 8.0

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

 create table test (
   `id` varchar(255) DEFAULT NULL,
    `credit_name` varchar(255) DEFAULT NULL,
    `credit_name2` varchar(255) DEFAULT NULL,
    `rate_home` float DEFAULT NULL,
    `rate_vehicle` float NOT NULL,
    `rate_need` float NOT NULL,
    `bankname` varchar(15)
   );


insert into test values 
(1,'Take Me','Take Me 2',10,5,15,'Bank A'),
(2,'Pick Me','Pick Me 2',15,20,8,'Bank B'),
(3,'Choo Me','Choo Me 2',20,25,45,'Bank C'),
(4,'Gett Me','Gett Me 2',35,12,4,'Bank D');
select * from test;


id
credit_name
credit_name2
rate_home
rate_vehicle
rate_need
bankname


1
Take Me
Take Me 2
10
5
15
Bank A

2
Pick Me
Pick Me 2
15
20
8
Bank B

3
Choo Me
Choo Me 2
20
25
45
Bank C

4
Gett Me
Gett Me 2
35
12
4
Bank D


select max(rate_home) as rate_home,max(rate_vehicle) as rate_vehicle, max(rate_need) as rate_need
from (   
SELECT  concat(t1.rate_home,' from ', t1.bankname) as rate_home ,
        null as rate_vehicle,
        null as rate_need
FROM test t1
LEFT JOIN test t2 ON t1.rate_home < t2.rate_home
WHERE t2.rate_home IS NULL
union
SELECT  null as rate_home,
        concat(t1.rate_vehicle,' from ', t1.bankname) as rate_vehicle ,
         null as rate_need
FROM test t1
LEFT JOIN test t2 ON t1.rate_vehicle < t2.rate_vehicle
WHERE t2.rate_vehicle IS NULL
union
SELECT  null as rate_home,
        null as rate_vehicle,
        concat(t1.rate_need,' from ', t1.bankname) as rate_need 
FROM test t1
LEFT JOIN test t2 ON t1.rate_need < t2.rate_need
WHERE t2.rate_need IS NULL ) as tbl;


rate_home
rate_vehicle
rate_need


35 from Bank D
25 from Bank C
45 from Bank C

id	credit_name	credit_name2	rate_home	rate_vehicle	rate_need	bankname
1	Take Me	Take Me 2	10	5	15	Bank A
2	Pick Me	Pick Me 2	15	20	8	Bank B
3	Choo Me	Choo Me 2	20	25	45	Bank C
4	Gett Me	Gett Me 2	35	12	4	Bank D