>>Sir,
>>
>>While using SQLSERVER 2012, I have these codes
>>
>>

>>USE at18;
>>IF OBJECT_ID('tempdb.dbo.#Table1', 'U') IS NOT NULL
>>  DROP TABLE #Table1; 
>> 
>>CREATE TABLE #Table1
>>(
>>code VARCHAR(50),
>>	names VARCHAR(50),
>>	country VARCHAR(50),
>>	qty int
>>)
>>
>>INSERT INTO #table1 VALUES (1104,'ERIC','Holland',45)
>>INSERT INTO #table1 VALUES (1105,'Boris','Bulgaria',50)
>>INSERT INTO #table1 VALUES (1106,'Anil','India',75)
>>INSERT INTO #table1 VALUES (1107,'Cetin','Turkey',65)
>>INSERT INTO #table1 VALUES (1105,'Boris','Bulgaria',40)
>>INSERT INTO #table1 VALUES (1104,'ERIC','Holland',65)
>>INSERT INTO #table1 VALUES (1107,'Cetin','Turkey',85)
>>INSERT INTO #table1 VALUES (1106,'Anil','India',25)
>>
>>select * from #table1 order by code
>>
>>select code,max(names)as names,max(country)as country,sum(qty)as qty 
>>from #Table1
>>group by code
>>order by code
>>

>>
>>The codes work fine like shown in attachment.
>>
>>I used max() clause to get all other columns except column that I used in group by.
>>
>>Is there any other methods to get above result without using max() clause?
>>
>>I mean ;With CTE or Join
>>
>>Please help
>
>Tariq,
>You don't really need max for other columns here. They are redundant, just include them in group by:
>
>

>select code,names,country,sum(qty)as qty 
>from #Table1
>group by code,names,country
>order by code
>

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