Advertisement
apl-mhd

TK convert update online 4

Jul 14th, 2018
153
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.27 KB | None | 0 0
  1. SELECT FIRST_NAME,
  2.  
  3. CASE
  4.     WHEN SALARY >1000 THEN
  5.     concat(SALARY DIV 1000, ' Thousands ', IF((MOD(SALARY, 1000))>0,
  6.                                            
  7.    concat( MOD(SALARY,1000) div 100, ' Houndreds TK'),'TK'))
  8.    
  9.    
  10.    
  11.  END
  12.  FROM employees;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement