Advertisement
apl-mhd

tk convert

Jul 8th, 2018
132
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.25 KB | None | 0 0
  1. SELECT FIRST_NAME,SALARY,
  2.     CASE
  3.         WHEN (SALARY div 1000 > 0) THEN  concat( SALARY div 1000, ' Thousands ',
  4.            IF( SALARY MOD 1000 > 0,  concat(FLOOR( SALARY MOD 1000),' houndred Tk'), 'Tk' ))
  5.                  
  6.      END
  7. FROM employees
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement