Hey Gopal:

You can even try this. Its very funny that sometimes u can laugh at the way you have written the query when u look into that after sometime again...

Hey Gopal:

If ur looking for the exact result what u have typed in ur message..check out this statement.

select (rtrim(t.col_a)+','+rtrim(min(a.col_b))+','+rtrim(cast(max(t.vol) as varchar(10))))

 as Final_Result

from testtbl a,

(select col_a,max(vol) as vol from testtbl...

Hey check it out!!!

select t.col_a,min(a.col_b) as col_b,max(t.vol) as vol from testtbl a,

(select col_a,max(vol) as vol from testtbl t group by col_a) t where

a.col_a=t.col_a and a.vol=t.vol group by t.col_a

Result of the...