Ivelin_1936

Untitled

Feb 16th, 2018
129
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.38 KB | None | 0 0
  1. CREATE FUNCTION ufn_get_salary_level(`parameter` DOUBLE(19,4))
  2. RETURNS VARCHAR(8)
  3. BEGIN
  4.     DECLARE result VARCHAR(8);
  5.     CASE
  6.         WHEN `parameter`< 30000
  7.             THEN SET `result` = 'Low';
  8.         WHEN `parameter`>= 30000 AND `parameter` <= 50000
  9.             THEN SET `result` = 'Average';
  10.         ELSE SET `result` = 'High';
  11.     END CASE;
  12.     RETURN `result`;
  13. END
Advertisement
Add Comment
Please, Sign In to add comment