Who to Insert data into ODD/EVEN rows only in SQL
I have one table with gender as one of the columns.
In gender column only M or F are allowed.
Now i want to sort the table so that while displaying the table in gender field M and F will come alternetivly.

I have Tried....
I have tried to create one(new) table with the same structure as my existing table.
Now using high leval insert i want to insert M to odd rows and F to even rows.
After that i want to join those two statements using union operator.
I am able to insert to  ( new ) the table only male or female but not to the even or odd rows...
Can any body help me regarding this....

Thanks in Advance....
 
Who to Insert data into ODD/EVEN rows only in SQL
===

I have one table with gender as one of the columns.
In gender column only M or F are allowed.
Now i want to sort the table so that while displaying the table in gender field M and F will come alternetivly.

I have Tried....
I have tried to create one(new) table with the same structure as my existing table.
Now using high leval insert i want to insert M to odd rows and F to even rows.
After that i want to join those two statements using union operator.
I am able to insert to  ( new ) the table only male or female but not to the even or odd rows...
Can any body help me regarding this....

Thanks in Advance....
 