select id , date_id , name

from 

(

select * , row_number() over(partition by date_id order by id ) as row_id from dddd 

) as t

where t.row_id <= 2 ;

row_number() over(partition by date_id order by id )