What if you simply query the database with two simple selects:
SELECT name FROM table WHERE name = 'surrender'
SELECT name FROM table WHERE name = 'govind'
This would give you all the records from each case. Now just loop through the ResultSets and interleave them.
You could also just do a simple: SELECT name FROM table and then just use some
Java logic on the ResultSet to get the data how you want it.
I don't know of anything in SQL to group the data like that, most of the time I am trying to sort like items together. I never tried alternating, I am not sure if SQL can do this, I will be interested to see what others come up with.
That may not be the best solution, but I think it could work. Maybe someone has some SQL mastery to solve this otherwise(I'm not great at SQL, just know enough to get by).
It might help to have some more background, why do you need to alternate the data? What else is i the table? I'm not sure if I really understand what you are getting here.