select case sex when '0' then '男' else '女' end as sss from student 或者select decode(sex ,'0','男','1','女') from student -- 这个好点。。。
