i have one student table
stu id sex coloums
1 male
2 female
3 female
4 male
5 female
i want retrieve the table male as female and female as male
want the result table liek this
stu id sex
1 f
2 m
3 m
4 f
5 m
can anyone tell me the query for this plz