Siga
@invertexto
Home
Blog
API
Sobre
Contato
Notepad Online
####### Inês######### pgdasd_03000_backup ; select filename, reg_posicao, reg, pa, id_declaracao, cnpj, uf, cod_tom, vltotal, sublimite, prex_int_sublimite, prex_int_limite, prex_ext_sublimite, prex_ext_limite, ind_impedimento_icms_iss, max(data_processamento ) from pgdasd_03000_backup group by filename, reg_posicao, reg, pa, id_declaracao, cnpj, uf, cod_tom, vltotal, sublimite, prex_int_sublimite, prex_int_limite, prex_ext_sublimite, prex_ext_limite, ind_impedimento_icms_iss order by filename desc pgdasd_03100_backup ; select filename, reg_posicao, reg, pa, id_declaracao, cnpj_03000, uf_03000, tipo, vltotal, max(data_processamento ) from pgdasd_03100_backup group by filename, reg_posicao, reg, pa, id_declaracao, cnpj_03000, uf_03000, tipo, vltotal order by filename desc pgdasd_03110_backup ; select filename, reg_posicao, reg, pa, id_declaracao, cnpj_03000, uf_03000, uf, tipo_03100, reg_posicao_03100, cod_tom, valor, cofins, csll, icms, inss, ipi, irpj, iss, pis, aliqapur, vlimposto, aliqapur_cofins, vlapurado_cofins, aliqapur_csll, vlapurado_csll, aliqapur_icms, vlapurado_icms, aliqapur_inss, vlapurado_inss, aliqapur_ipi, vlapurado_ipi, aliqapur_irpj, vlapurado_irpj, aliqapur_iss, vlapurado_iss, aliqapur_pis, vlapurado_pis, max(data_processamento ) from pgdasd_03110_backup group by filename, reg_posicao, reg, pa, id_declaracao, cnpj_03000, uf_03000, uf, tipo_03100, reg_posicao_03100, cod_tom, valor, cofins, csll, icms, inss, ipi, irpj, iss, pis, aliqapur, vlimposto, aliqapur_cofins, vlapurado_cofins, aliqapur_csll, vlapurado_csll, aliqapur_icms, vlapurado_icms, aliqapur_inss, vlapurado_inss, aliqapur_ipi, vlapurado_ipi, aliqapur_irpj, vlapurado_irpj, aliqapur_iss, vlapurado_iss, aliqapur_pis, vlapurado_pis order by filename desc pgdasd_03111_backup ; select filename, reg_posicao, reg, pa, id_declaracao, cnpj_03000, tipo_03100, reg_posicao_03110, valor, max(data_processamento ) from pgdasd_03111_backup group by filename, reg_posicao, reg, pa, id_declaracao, cnpj_03000, tipo_03100, reg_posicao_03110, valor order by filename desc pgdasd_03112_backup ; select filename, reg_posicao, reg, pa, id_declaracao, cnpj_03000, tipo_03100, reg_posicao_03110, valor, reducao, max(data_processamento ) from pgdasd_03112_backup group by filename, reg_posicao, reg, pa, id_declaracao, cnpj_03000, tipo_03100, reg_posicao_03110, valor, reducao order by filename desc ########################################################################################################################### Mara: select filename, reg_posicao, reg, cod_ver, dt_ini, dt_fin, reg_zzzzz, qtd_declaracao, max(data_processamento ) from pgdasd_aaaaa_backup group by filename, reg_posicao, reg, cod_ver, dt_ini, dt_fin, reg_zzzzz, qtd_declaracao order by filename desc ####### Bruno ###### SELECT * FROM pgdasd_00000_backup where (filename = '90-0000-PUB-PGDASD2018-20240508-01.zip' and data_processamento >= '2024-05-13') or(filename != '90-0000-PUB-PGDASD2018-20240508-01.zip') order by filename DESC; SELECT filename ,reg_posicao ,reg ,pgdasd_id_declaracao ,pgdasd_num_recibo ,pgdasd_num_autenticacao ,pgdasd_dt_transmissao ,pgdasd_versao ,cnpjmatriz ,nome ,cod_tom ,optante ,abertura ,pa ,rpa ,r ,operacao ,regime ,rpac ,rpa_int ,rpa_ext ,rpac_int ,rpac_ext ,ind_retido_malha ,nu_ip ,nu_certificado_digital ,reg_posicao_99999 ,reg_99999 ,MAX(data_processamento) FROM stsnnp02.pgdasd_00000_backup GROUP BY filename ,reg_posicao ,reg ,pgdasd_id_declaracao ,pgdasd_num_recibo ,pgdasd_num_autenticacao ,pgdasd_dt_transmissao ,pgdasd_versao ,cnpjmatriz ,nome ,cod_tom ,optante ,abertura ,pa ,rpa ,r ,operacao ,regime ,rpac ,rpa_int ,rpa_ext ,rpac_int ,rpac_ext ,ind_retido_malha ,nu_ip ,nu_certificado_digital ,reg_posicao_99999 ,reg_99999 order by filename DESC; SELECT filename ,reg_posicao ,reg ,pa ,id_declaracao ,admtrib ,uf ,munic ,codmunic ,numproc ,MAX(data_processamento) FROM stsnnp02.pgdasd_00001_backup GROUP BY filename ,reg_posicao ,reg ,pa ,id_declaracao ,admtrib ,uf ,munic ,codmunic ,numproc order by filename DESC; SELECT filename ,reg_posicao ,reg ,pa ,id_declaracao ,nrpagto ,princ ,multa ,juros ,tdevido ,dtvenc ,dtvalcalc ,dt_emissao_das ,MAX(data_processamento) FROM stsnnp02.pgdasd_01000_backup GROUP BY filename ,reg_posicao ,reg ,pa ,id_declaracao ,nrpagto ,princ ,multa ,juros ,tdevido ,dtvenc ,dtvalcalc ,dt_emissao_das order by filename DESC; SELECT filename ,reg_posicao ,reg ,pa ,id_declaracao ,nrpagto_01000 ,codrecp ,valorprinc ,codrecm ,valorm ,codrecj ,valorj ,uf ,codmunic ,MAX(data_processamento) FROM stsnnp02.pgdasd_01100_backup GROUP BY filename ,reg_posicao ,reg ,pa ,id_declaracao ,nrpagto_01000 ,codrecp ,valorprinc ,codrecm ,valorm ,codrecj ,valorj ,uf ,codmunic order by filename DESC; SELECT filename ,reg_posicao ,reg ,pa ,id_declaracao ,rbt12 ,rbtaa ,rba ,rbt12o ,rbtaao ,icms ,iss ,rbtaa_int ,rbtaa_into ,rbtaa_ext ,rbtaa_exto ,rbt12_int ,rbt12_into ,rba_int ,rba_ext ,rbt12_ext ,rbt12_exto ,MAX(data_processamento) FROM stsnnp02.pgdasd_02000_backup GROUP BY filename ,reg_posicao ,reg ,pa ,id_declaracao ,rbt12 ,rbtaa ,rba ,rbt12o ,rbtaao ,icms ,iss ,rbtaa_int ,rbtaa_into ,rbtaa_ext ,rbtaa_exto ,rbt12_int ,rbt12_into ,rba_int ,rba_ext ,rbt12_ext ,rbt12_exto order by filename DESC;
invertexto.com/tabelas
Mudar URL
Adicionar Senha
Compartilhar
×
Mudar URL
×
Adicionar Senha
Senha
E-Mail
(utilizado para recuperação de senha)
×
Compartilhar
