sql server 2008 - Remove a column after selection with SQL -

i want result set include 1 column, i'm using different column group , order by. can somehow, after selecting , order removing column result set?

using mssql2008

just add select around query, so:

select      sum_columnb (select      columna     , sum(columb) sum_columnb table group columna order columna        , sum_columnb) resultset 

but if post query, answer more specific , maybe clearer.