Home / File / isisdoc.chm

isisdoc.chm

Posted on
  • Version
  • Download 14
  • File Size 212.55 KB
  • File Count 1
  • Create Date 18 aprilie 2016
  • Last Updated 27 noiembrie 2018

isisdoc.chm

Numarare angajati din Statistici (2) SalFisaAN.dbf: contortot=numar total de aparitii, contor=numar aparitii pentru fiecare cnp

Pe la Admin DB

Grupe majore
SELECT LEFT(mesercod,1) AS 'grupacod', COUNT (*) AS 'contortot', COUNT (DISTINCT cnp) AS 'contor' FROM (dir_Luti+"SalFisaAN.DBF") GROUP BY 1 INTO CURSOR crsTest
BROW NORMAL IN SCREEN

SELECT LEFT(functiacod,1) AS 'grupacod', COUNT (*) AS 'contortot', COUNT (DISTINCT cnp) AS 'contor' FROM (dir_Luti+"SalFisaAN.DBF") GROUP BY 1 INTO CURSOR crsTest
BROW NORMAL IN SCREEN

Grupe minore
SELECT LEFT(mesercod,3) AS 'grupacod', COUNT (*) AS 'contortot', COUNT (DISTINCT cnp) AS 'contor' FROM (dir_Luti+"SalFisaAN.DBF") GROUP BY 1 INTO CURSOR crsTest
BROW NORMAL IN SCREEN

SELECT LEFT(functiacod,3) AS 'grupacod', COUNT (*) AS 'contortot', COUNT (DISTINCT cnp) AS 'contor' FROM (dir_Luti+"SalFisaAN.DBF") GROUP BY 1 INTO CURSOR crsTest
BROW NORMAL IN SCREEN

Top