IZM>select cName,  nBall, DDate 
IZM>from 
IZM>(select cName,  nBall, DDate, Row_number() over (partition by cName order by Cname ,Nball, Ddate) as NN from tb_test1) 
IZM>where NN=1
IZM>