1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
| SQL> drop table toto;
Table dropped.
SQL> CREATE TABLE toto AS
2 WITH t AS (SELECT 1 num, 'Pierre' nom, 10 n1, 15 n2 FROM dual
3 UNION ALL SELECT 2, 'Pierre', 10, 15 FROM dual
4 UNION ALL SELECT 3, 'Pierre', 10, 15 FROM dual
5 UNION ALL SELECT 4, 'Paul', 12, 18 FROM dual
6 UNION ALL SELECT 5, 'Paul', 12, 18 FROM dual)
7 SELECT ROWNUM num, nom, n1,n2, nb
8 FROM (SELECT nom, n1, n2, COUNT(*) nb FROM t GROUP BY nom, n1, n2);
Table created.
SQL> select * from toto;
NUM NOM N1 N2 NB
---------- ------ ---------- ---------- ----------
1 Paul 12 18 2
2 Pierre 10 15 3 |
Partager