Solved programming problem

Show each employees employee_id, first_name and his salary in - 10 thousands 5 hundreds and 12 taka only format

Source code

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
Join the discussion

Add your comment