SELECT EMPLOYEE_ID,FIRST_NAME,
CONCAT(SALARY DIV 1000,"thousands ",(SALARY MOD 1000) DIV 100 ," hundreds and ", ((SALARY MOD 1000) DIV 100) MOD 100," taka only")
FROM employees
SELECT EMPLOYEE_ID,FIRST_NAME,
CONCAT(SALARY DIV 1000,"thousands ",(SALARY MOD 1000) DIV 100 ," hundreds and ", ((SALARY MOD 1000) DIV 100) MOD 100," taka only")
FROM employees
Add your comment