CASE
-- กรณี Creatinine < 10
WHEN U_CREA < 10 AND U_ALB < 10 THEN 'Re-Collect'
WHEN U_CREA < 10 AND U_ALB = 10 THEN 'Re-Collect'
WHEN U_CREA < 10 AND U_ALB >= 30 THEN 'N/A'
-- กรณี Creatinine = 10
WHEN U_CREA = 10 AND U_ALB < 10 THEN 'Re-Collect'
WHEN U_CREA = 10 AND U_ALB = 10 THEN 'Re-Collect'
WHEN U_CREA = 10 AND U_ALB = 30 THEN 300
WHEN U_CREA = 10 AND U_ALB = 80 THEN 800
WHEN U_CREA = 10 AND U_ALB = 150 THEN 1500
WHEN U_CREA = 10 AND U_ALB > 150 THEN '>300'
-- กรณี Creatinine = 50
WHEN U_CREA = 50 AND U_ALB < 10 THEN '<30'
WHEN U_CREA = 50 AND U_ALB = 10 THEN 20
WHEN U_CREA = 50 AND U_ALB = 30 THEN 60
WHEN U_CREA = 50 AND U_ALB = 80 THEN 160
WHEN U_CREA = 50 AND U_ALB = 150 THEN 300
WHEN U_CREA = 50 AND U_ALB > 150 THEN '>300'
-- กรณี Creatinine = 100
WHEN U_CREA = 100 AND U_ALB < 10 THEN '<30'
WHEN U_CREA = 100 AND U_ALB = 10 THEN 10
WHEN U_CREA = 100 AND U_ALB = 30 THEN 30
WHEN U_CREA = 100 AND U_ALB = 80 THEN 80
WHEN U_CREA = 100 AND U_ALB = 150 THEN 150
WHEN U_CREA = 100 AND U_ALB > 150 THEN '>300'
-- กรณี Creatinine = 200
WHEN U_CREA = 200 AND U_ALB < 10 THEN '<30'
WHEN U_CREA = 200 AND U_ALB = 10 THEN 5
WHEN U_CREA = 200 AND U_ALB = 30 THEN 15
WHEN U_CREA = 200 AND U_ALB = 80 THEN 40
WHEN U_CREA = 200 AND U_ALB = 150 THEN 75
WHEN U_CREA = 200 AND U_ALB > 150 THEN '>300'
-- กรณี Creatinine = 300
WHEN U_CREA = 300 AND U_ALB < 10 THEN '<30'
WHEN U_CREA = 300 AND U_ALB = 10 THEN 3
WHEN U_CREA = 300 AND U_ALB = 30 THEN 10
WHEN U_CREA = 300 AND U_ALB = 80 THEN 27
WHEN U_CREA = 300 AND U_ALB = 150 THEN 50
WHEN U_CREA = 300 AND U_ALB > 150 THEN '>300'
-- กรณี Creatinine > 300
WHEN U_CREA > 300 AND U_ALB < 10 THEN '<30'
WHEN U_CREA > 300 AND U_ALB = 10 THEN '<30'
WHEN U_CREA > 300 AND U_ALB = 30 THEN '<30'
WHEN U_CREA > 300 AND U_ALB = 80 THEN '<30'
WHEN U_CREA > 300 AND U_ALB = 150 THEN '<30'
WHEN U_CREA > 300 AND U_ALB > 150 THEN 'N/A'
ELSE NULL
END
To embed this project on your website, copy the following code and paste it into your website's HTML: