>>
>>Sir I wrote this query by myself
>>

>>SELECT  a.code, a.names, a.country,b.qty 
>>FROM #table1  a, 
>>   (
>>   SELECT code, sum(qty)as qty
>>FROM #table1
>> GROUP BY code
>> ) b
>>WHERE a.code = b.code
>>

>>
>>This display the correct sum of qty but with double row like this
>>
>>1104 ERIC Holland 110
>>1104 ERIC Holland 110
>>1105 Boris Bulgaria 90
>>1105 Boris Bulgaria 90
>>1106 Anil India 100
>>1106 Anil India 100
>>1107 Cetin Turkey 150
>>1107 Cetin Turkey 150
>>
>>It will be great help if you modify this query.
>>
>>Please
>
>If you meant to get this output, then it is a correct way to write it. Another way is:
>
>

>SELECT code, names, country,
>       SUM(qty) OVER (PARTITION BY code) AS qty
>FROM #Table1
>ORDER BY code;
>

Sir your above query shows double result like shown in attachment.