MY Favorite .Net Question For Interview
This are not tidy. Just for rough. In Sha Allah will make it tiddy soon. 1. DateTime2 Date range 0001-01-01 through 9999-12-31 vs Date...
Users Countries
Wednesday, December 2, 2015
Monday, November 30, 2015
Oracle CASE Practice
Muhammad Ashikuzzaman
November 30, 2015
0
SELECT CODE, CASE(NAME_EN)
WHEN 'Teacher' then 'Head Teacher'
WHEN 'Maulna' then 'Head Maulana'
ELSE NAME_EN
END TITLE_EGLISH
FROM IMS_SETUP_DESIGNATION_TO;
Here NAME_EN is a column of IMS_SETUP_DESIGNATION_TO table but it also may be a variable.