select max(id) as id,name,max(age) as tempage from table group by name
create table m(id int , name char, age int) insert m select 1, 'a', 20 insert m select 2, 'a', 30 insert m select 3, 'b', 10 insert m select 4, 'b', 40select m.* from m ,(select name,max(age) as age from m group by name)#t where m.name=#t.name and m.age=#t.age order by m.iddrop table m
回: 回复人: hdhai9451(※★山,快馬加鞭未下鞍...☆※) ( ) 信誉:100 你的答案不对啊! 如: create table m(id int , name char, age int) insert m select 1, 'a', 20 insert m select 2, 'a', 30 insert m select 3, 'b', 10 insert m select 4, 'b', 40 insert m select 5, 'a', 10select max(id) as id,name,max(age) as tempage from m group by name 结果: id name tempage ----- ------ ------- 5 a 30 4 b 40这样明显不对嘛!
insert m select 1, 'a', 20
insert m select 2, 'a', 30
insert m select 3, 'b', 10
insert m select 4, 'b', 40select m.* from m ,(select name,max(age) as age from m group by name)#t
where m.name=#t.name and m.age=#t.age order by m.iddrop table m
回复人: hdhai9451(※★山,快馬加鞭未下鞍...☆※) ( ) 信誉:100
你的答案不对啊!
如:
create table m(id int , name char, age int)
insert m select 1, 'a', 20
insert m select 2, 'a', 30
insert m select 3, 'b', 10
insert m select 4, 'b', 40
insert m select 5, 'a', 10select max(id) as id,name,max(age) as tempage from m group by name
结果:
id name tempage
----- ------ -------
5 a 30
4 b 40这样明显不对嘛!