>>
>>Thanks sir Cetin Basoz for helping but I do not want to use more than one column in group by clause.
>>Is it possible to use ;with cte or some alternative method?
>>
>>Please
>
>If you look at it from possibility point, yes it is possible. ie:
>
>

>WITH totals (code, qty) AS 
>(SELECT code, SUM(qty)
>    FROM #Table1
>    GROUP BY code)
>SELECT t1.code, tn.Names, tn.Country, t1.qty
>FROM totals t1
>    CROSS APPLY (SELECT TOP (1) names, country
>    FROM #Table1 t2
>    WHERE t1.code = t2.code) tn(Names, Country)
>ORDER BY t1.code;
>

Thanks sir, it works