Getting a recordID in my SQL select query

Viewed 11151

I have a simple stored procedure that returns records:

Select empID, EmpFirstName, EmpLastName from EMPLOYEES  

The returned result is:

    EmpID         EmpFirstName       EmpLastName  
    -----         ------------       -----------  
   30152          John               Smith  
   30114          Tom                Jones  
   56332          Steve              Williams  
   85442          Paul               Johnson  

What I need is:

 RecID       EmpID         EmpFirstName       EmpLastName  
 -----       -----         ------------       -----------  
 1      30152          John               Smith  
 2      30114          Tom                Jones  
 3      56332          Steve              Williams  
 4      85442          Paul               Johnson  

How can I get the recordID column?

Thanks

3 Answers
Related