create table tt
(
A varchar(2),
B varchar(2),
C varchar(2),
D varchar(2),
E varchar(2),
F varchar(2)
)
insert into tt values('1','2','3','4','5','6')
insert into tt values('2','A','3','B','C','L')
select * from tt
select (select top 1 A from tt order by A desc),
(select top 1 B from tt order by B desc),
(select sum(cast(C as int)) from tt),
(select top 1 D from tt order by D desc),
(select top 1 E from tt order by E desc),
(select top 1 F from tt order by F desc)