110,534
社区成员
发帖
与我相关
我的任务
分享
select * from
Province join
(
select
person.name as name,
max(person.age) as age,
max(person.weight) as weight,
max(provinceName) as ProvinceName
from person as p
group by name
)
on p.provincename = province.id
select a.id,a.name,a.age,a.high,a.weight,b.provincename
from person a,province b
where a.provincename=b.id
select
a.id,a.name,a.age,a.high,a.weight,b.provincename
from
(
select max(id) as id,name,max(age) as age,max(high) as high,max(weight) as weight,max(provincename) as provincename from Person
group by name
) a left join province b on a.provincename=b.id
select t.* from
(
select t1.Id,t1.Name,t1.Age, t1.High, t1.Weight, t2.ProvinceName
from Person as t1 inner join Province as t2
on t1.id=t2.id
) t
where t.id = (select top 1 tt.id from Person as tt where tt.Name=t.Name)
select a.*,b.ProvinceName from Person a inner join Province b on a.[province.id]=b.id where a.Id in (select min(Id) from Person group by Name)