>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

You can extent the group by to eliminate the MAX()

GROUP BY Code, Names, Country

Using a Join any other technique would be much more costly.