getting a consecutive string value from database through JDBC

Hi All ,
Can you help me with this solution .I have a employee table with column employee id .

I want to have SQL procedure or query to where current employee id =prevoius employeeid +1

Thanks

Just use math:

Code :

---

SELECT whatever_columns FROM whatever_table WHERE my_id=previous_id+1;

---