Person:
Id | Name | Age | Sex |
1 | 小A | 18 | 1 |
2 | 小B | 23 | 0 |
sql example:
select ROW_NUMBER() over (partition by Sex, Age order by Sex,Age) as number,Person.*
into #tp1
from Person
select * from #tp1 where number = 1
drop table #tp1
Person:
Id | Name | Age | Sex |
1 | 小A | 18 | 1 |
2 | 小B | 23 | 0 |
sql example:
select ROW_NUMBER() over (partition by Sex, Age order by Sex,Age) as number,Person.*
into #tp1
from Person
select * from #tp1 where number = 1
drop table #tp1