Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT FIRST_NAME,
- CASE
- WHEN SALARY >1000 THEN
- concat(SALARY DIV 1000, ' Thousands ', IF((MOD(SALARY, 1000))>0,
- concat( MOD(SALARY,1000) div 100, ' Houndreds TK'),'TK'))
- END
- FROM employees;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement