34,593
社区成员
发帖
与我相关
我的任务
分享
drop table #student
create table #student(name char(9),age int)
insert into #student(name,age) values('name1', 22)
insert into #student(name,age) values('name2', 25)
insert into #student(name,age) values('name3', 32)
insert into #student(name,age) values('name4', 52)
insert into #student(name,age) values('name5', 19)
Select max(age), count(1) from #student