a4a:Convenções/Dados/SQL: mudanças entre as edições
m (cep5 report) |
m (→Queries) |
||
Linha 101: | Linha 101: | ||
from optim.vw_jurisdiction76_postal_ranges | from optim.vw_jurisdiction76_postal_ranges | ||
) t order by 10 desc, 1 | ) t order by 10 desc, 1 | ||
; | ; -- MEDIANA 71 km2, select PERCENTILE_CONT(0.5) WITHIN GROUP(ORDER BY area_per_cep) FROM (...) t2. | ||
</syntaxhighlight> | </syntaxhighlight> | ||