Дt
Valery Dva
а так :
WITH
cte AS
(SELECT
*,
ROW_NUMBER() over(partition by s_tip order by isNull(tIn.s_sum, 0) + isNull(tIn.s_sum2, 0) desc) as num
FROM table
)
SELECT
*
FROM
cte
WHERE
num = 1
ну примерно так я и сделал, только без СТЕ
