By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
WITH tms AS (
SELECT 1 AS ID, '2017-01-01 00:00:00' AS tid, -757 AS tse1, -1052 AS tse2, -4200 AS bse1, -940 AS bse2 UNION ALL
SELECT 2, '2017-01-01 01:00:00', -752, -1058, -4175, -882 UNION ALL
SELECT 3, '2017-01-01 02:00:00', -754, -1068, -4112, -906 UNION ALL
SELECT 4, '2017-01-01 03:00:00', -754, -1057, -4135, -905 UNION ALL
SELECT 5, '2017-01-01 04:00:00', -766, -1066, -4140, -911 UNION ALL
SELECT 6, '2017-01-01 05:00:00', -767, -1084, -4156, -916 UNION ALL
SELECT 7, '2017-01-01 06:00:00', -763, -1092, -4225, -924 UNION ALL
SELECT 8, '2017-01-01 07:00:00', -756, -1086, -4322, -973 UNION ALL
SELECT 9, '2017-01-01 08:00:00', -779, -1105, -4415, -989 UNION ALL
SELECT 10, '2017-01-01 09:00:00', -781, -1114, -4459, -985 UNION ALL
SELECT 11, '2017-01-01 10:00:00', -778, -1124, -4579, -1009 UNION ALL
SELECT 12, '2017-01-01 11:00:00', -783, -1134, -4691, -1010 UNION ALL
SELECT 13, '2017-01-01 12:00:00', -785, -1144, -4000, -1018
)
SELECT ID
FROM
(
SELECT *, RANK() OVER (ORDER BY bse1 + bse2 DESC) rnk
FROM tms
) t
WHERE rnk = 1;
| ID |
|---|
| 3 |
| 13 |