"dup4" - 1 õppematerjal

ORACLE: SQL JA PLSQL 12

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(*) ------------------------ -------- ------ ---------- 10020015 Iad307 1 2 10020013 ID218 1 2 10020014 I319 1 2 SQL> VARIABLE parim NUMBER;