Advertisement
Guest User

Untitled

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