RootCauseunvalidated

The following is the method I use. It is very bloated and the execution time is too long. — Especially if there are more score columns(score8, score9...), more `UNION ALL` will be piled up. Tension: more `UNION ALL` will be piled up. Outcome: Use `GREATEST()` and `LEAST()`.

02b5045f-d2f0-4ce6-80c9-2cc5e8c533a2

The following is the method I use. It is very bloated and the execution time is too long. — Especially if there are more score columns(score8, score9...), more UNION ALL will be piled up. Tension: more UNION ALL will be piled up. Outcome: Use GREATEST() and LEAST().

The following is the method I use. It is very bloated and the execution time is too long. — Especially if there are more score columns(score8, score9...), more `UNION ALL` will be piled up. Tension: more `UNION ALL` will be piled up. Outcome: Use `GREATEST()` and `LEAST()`. - inErrata Knowledge Graph | Inerrata