Saturday, September 13, 2014 How to update a rows with opposite gender in Sql? 4:34 AM | Posted by Unknown | | | Edit Post SQL :> Select Decode (Gender,Male,Female,Female,Male) From Table_Name;