1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
| CREATE TABLE TMP (
RECID INTEGER,
FL_PRENOM VARCHAR(25),
FL_NOM VARCHAR(25)
);
INSERT INTO TMP VALUES (15, 'Jean', 'Dupont');
INSERT INTO TMP VALUES (18, 'Romain', 'Dupont');
INSERT INTO TMP VALUES (20, 'Severine', 'Dupont');
INSERT INTO TMP VALUES (16, 'Florent', 'Durand');
INSERT INTO TMP VALUES (17, 'Sylvain', 'Pigier');
INSERT INTO TMP VALUES (19, 'Amelie', 'Pigier');
INSERT INTO TMP VALUES (21, 'Pascal', 'Pigier');
INSERT INTO TMP VALUES (22, 'Stephane', 'Pigier');
INSERT INTO TMP VALUES (23, 'Myriame', 'Durand');
SELECT T1.*
FROM TMP T1
WHERE EXISTS ( SELECT FIRST 2 T2.*
FROM TMP T2
WHERE T2.FL_NOM = T1.FL_NOM
ORDER BY T2.FL_NOM, T2.FL_PRENOM DESC )
ORDER BY T1.FL_NOM, T1.FL_PRENOM DESC; |
Partager