Pessoal, é possível utilizar window function para "melhorar" a select abaixo:?
SELECT (SELECT COUNT(*) FROM orcamento_venda WHERE (orv_codemp = 1) AND (orv_codfilial = 1)) AS totorv , (SELECT COUNT(*) FROM orcamento_venda WHERE (orv_codemp = 1) AND (orv_codfilial = 1) AND (orv_codsituacao = 5)) AS total , (SELECT string_agg(orv_codorcamento::text,',') FROM orcamento_venda WHERE (orv_codemp = 1) AND (orv_codfilial = 1) AND (orv_codsituacao = 5)) AS codigos , (ROUND((((SELECT COUNT(*) FROM orcamento_venda WHERE (orv_codemp = 1) AND (orv_codfilial = 1) AND (orv_codsituacao = 5)) * 100)::numeric / (SELECT COUNT(*) FROM orcamento_venda WHERE (orv_codemp = 1) AND (orv_codfilial = 1))::numeric),2)) AS percentual []s Danilo
_______________________________________________ pgbr-geral mailing list pgbr-geral@listas.postgresql.org.br https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
