19 lines
485 B
Plaintext
19 lines
485 B
Plaintext
begin
|
|
|
|
SELECT
|
|
CASE
|
|
WHEN AntropometriType = 'MIN' THEN 'Nilai Minimal'
|
|
WHEN AntropometriType = 'MAX' THEN 'Nilai Maksimal'
|
|
WHEN AntropometriType = 'AVG' THEN 'Rata - rata'
|
|
WHEN AntropometriType = 'MED' THEN 'Median'
|
|
ELSE AntropometriType
|
|
END AS AntropometriType ,
|
|
AntropometriTB,
|
|
AntropometriBB,
|
|
AntropometriLP,
|
|
AntropometriBMI,
|
|
AntropometriMgm_McuID
|
|
FROM one_etl.antropometri
|
|
WHERE AntropometriMgm_McuID = PID;
|
|
|
|
end |