>
>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;