Ò»¸ö¹ØÓÚ SQLÓï¾äµÄÎÊÌâ

name address num
21  'asddd' 34
21  'asss'  33
21  'zxas'  29
22  'dongx' 25
22  'chang' 34
ÎÒÏÖÔÚÏë¸ù¾ÝÐÕÃû·ÖÀ࣬ȻºóÈ¡³öÿ¸öÓû§ÏÂÃænum×î´óµÄÄÇÌõ¼Ç¼¡£
³ýÁËÕâ¸ö·½·¨
select min(name),min(address),max(num)
from table
group by name

ллÁË

---

SQL code:
--> ²âÊÔÊý¾Ý£º[TB]
if object_id('[TB]') is not null drop table [TB]
create table [TB]([name] int,[address] varchar(5),[num] int)
insert [TB]
select 21,'asddd',34 union all
select 21,'asss',33 union all
select 21,'zxas',29 union all
select 22,'dongx',25 union all
select 22,'chang',34

select * from [TB] t where not exists(select 1 from TB where t.name=name and t.num<num)

/*
name address num
----------- ------- -----------
21 asddd 34
22 chang 34

£¨ËùÓ°ÏìµÄÐÐÊýΪ 2 ÐУ©

*/
drop table TB

---

Ϊʲô²»ÒªÓÃgroup by£¿