Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE OR REPLACE FORCE VIEW "NEW" ("VISI PACIENTAI", "REGISTRUOTI PACIENTAI", "VISOS LIGONINES", "VISI GYDYTOJAI", "2019 METŲ REGISTRACIJOS", "2020 METŲ REGISTRACIJOS", "2021 METŲ REGISTRACIJOS", "ŠIO MĖNESIO REGISTRACIJOS", "VISU VAISTU ESANČIU DUOMENŲ BAZĖJE SUMA") AS
- SELECT(
- SELECT COUNT(*) FROM PACIENTAS
- WHERE ASMENSKODAS > 0
- ) AS VISIPACIENTAI,
- (SELECT COUNT(*) FROM REGISTRACIJA) AS REGPACIENTAI,
- (SELECT COUNT(*) FROM LIGONINE) AS VISOSLIGONINES,
- (SELECT COUNT(*) FROM GYDYTOJAS) AS VISIGYDYTOJAI,
- (SELECT COUNT(*) FROM REGISTRACIJA
- WHERE REGISTRACIJOSDATA > TO_DATE('01/01/2019', 'mm/dd/yyyy')
- ) AS DEVINIOLIKTI,
- (SELECT COUNT(*) FROM REGISTRACIJA
- WHERE REGISTRACIJOSDATA > TO_DATE('01/01/2020', 'mm/dd/yyyy')
- ) AS DVIDESIMTI,
- (SELECT COUNT(*) FROM REGISTRACIJA
- WHERE REGISTRACIJOSDATA > TO_DATE('01/01/2021', 'mm/dd/yyyy')
- ) AS DVIDEMITPIRMI,
- (SELECT COUNT(*) FROM REGISTRACIJA
- WHERE REGISTRACIJOSDATA > TO_DATE('12/01/2019', 'mm/dd/yyyy')
- ) AS MENUO,
- (SELECT SUM(KAINA) FROM VAISTAI
- ) AS SUMA
- FROM dual
- /
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement