"dup2" - 1 õppematerjal

ORACLE: SQL JA PLSQL 12

txt 5 10020011 I319 12-MAR-03 3 01.txt 6 15 rows selected. SQL> SELECT k.yliopilase_id, k.kursusekood, k.too_nr, COUNT(*) FROM koduylesanded k 2 GROUP BY yliopilase_id, kursusekood, too_nr 3 HAVING COUNT(*) > 1; no rows selected SQL> INSERT INTO koduylesanded VALUES (10020014, 'I319', '11-JUN-03', 1, 'dup1.txt', 9); 1 row created. SQL> INSERT INTO koduylesanded VALUES (10020015, 'Iad307', '06-JUN-03', 1, 'dup2.txt', 9); 1 row created. SQL> INSERT INTO koduylesanded VALUES (10020011, 'Iad307', '01-JUN-03', 3, 'dup3.txt', 8); 1 row created. SQL> INSERT INTO koduylesanded VALUES (10020013, 'ID218', '03-JUN-03', 1, 'dup4.txt', 8); 1 row created. SQL> SELECT k.yliopilase_id, k.kursusekood, k.too_nr, COUNT(*) FROM koduylesanded k 2 GROUP BY yliopilase_id, kursusekood, too_nr 3 HAVING COUNT(*) > 1; YLIOPILASE_ID KURSUSEK TOO_NR COUNT(*)