I am trying to count the number of entries in each UNI.
However i do not get a count for 0
I would like the return to be:
UNI Entries
POL 1
GYM 3
XXX 0
IDS TABLE
CREATE TABLE DAN_GR
(ID VARCHAR2(8),
UNI VARCHAR2(8))
INSERT INTO DAN_GR (ID,UNI) VALUES (1,'POL');
INSERT INTO DAN_GR (ID,UNI) VALUES (2,'GYM');
INSERT INTO DAN_GR (ID,UNI) VALUES (3,'GYM');
INSERT INTO DAN_GR (ID,UNI) VALUES (4,'GYM');
BANK TABLE
CREATE TABLE DAN_BANK2
(UNI VARCHAR2(8))
INSERT INTO DAN_BANK2 (UNI) VALUES ('POL');
INSERT INTO DAN_BANK2 (UNI) VALUES ('SYM');
INSERT INTO DAN_BANK2 (UNI) VALUES ('XXX');
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi