Create New Data Table From Select Statement Results
SELECT masv,hodem,name,CASE gioitinh WHEN 1 THEN Nam ELSE Female END AS gioitinh FROM sinhvien or SELECT name, address, name, CASE WHEN gioitinh=1 THEN Male ELSE Female END AS gioitinh FROM sinhvien The results of the two statements above are in the following form: Constants and expressions in the ...












