ranking each employee

[ppatel]

Hi, I have set for questions for each employee, i need to just number
each record

Example
------------------------

EmpNo QuestionNo RecordNo
-----------------------------------------------------------
1001 1 1
1001 2 2
1001 4 3
1002 1 1
1002 6 2
1003 1 1

For each employee I need record number, and i have over 10000 records
so something automated would be really helpful

Thanks