SQL问题 - 编程论坛

#2

Vitamin19992009-10-13 10:55

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)

#3

msgj2009-10-13 10:58

sql="SELECT max(A) as AA,max(B) as BB,sum(C) as CC,max(D) as DD,max(E) as EE,max(F) as FF FROM 表名"

#4

Vitamin19992009-10-14 10:38

3楼的大侠比我的简单多了佩服佩服