привет всем, есть кто в sql шарит
пишу запрос
SELECT
count(1) as 'Количество покупок в ТДД',
sum([Count S1]) as 's1',
sum([Count S2]) as 's2',
sum([Count S3]) as 's3',
sum([Count S4]) as 's4',
sum([Count S5]) as 's5'
FROM [DS].[card_price_segments] as b INNER JOIN [DS1].[product_price_segments] as c
on b.product_id = c.product_id
where [Card Number] = '123123'
and c.[Macro Category] = 'ТДД'
Получаю: см скрин
А хочу брать максимум из (s1,s2,s3,s4,s5)
Типа: см 2 скрин