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