|
|
От: | IZM | |
| Дата: | 09.06.22 03:12 | ||
| Оценка: | |||
select a.CName, a.nMinball, min(b.ddate) as DMinDate
from
(select cName, min(nBall) as nMinBall
from tb_test1
group by cName
) a
join tb_test1 b on (b.cName=a.cname and b.nBall=a.nminball)
group by a.CName, a.nMinball