to get the employee data with the number

try this query

this query gives employee data with the number

select MID, Status, Code, row_number() over (partition by code order by MID) as number

from...