select * from transactions_jour
NUMTRANSACTION_JOUR MONTANT IDMEMBRE IDPARTENAIRE DATETRANSA
CTION
------------------- ------------------------ ----------- ------------ ----------
----------------
6 +4,12000000000000E+002 12 31 2005-10-01
-10.51.44.000000
7 +3,60000000000000E+001 12 31 2005-10-01
-10.52.47.000000
8 +3,60000000000000E+001 12 31 2005-10-01
-10.53.22.000000
9 +3,60000000000000E+001 8 158 2005-10-01
-10.54.37.000000
10 +2,40000000000000E+001 45 28 2005-10-01
-10.56.07.000000
999 +3,60000000000000E+001 12 31 2005-10-01
-10.59.00.000000
6 record(s) selected.
SELECT Count(*) AS Expr1, TP.idmembre, TP.montant, TP.idpartenaire FROM transact
ions_jour AS TP INNER JOIN transactions_jour AS TD ON (TP.montant = TD.montant)
AND (TP.idpartenaire = TD.idpartenaire) AND (TP.idmembre = TD.idmembre) WHERE ((
(TP.datetransaction)>=(TD.datetransaction) And (TP.datetransaction)<=(Td.datetra
nsaction + 5 minutes))) GROUP BY TP.idmembre, TP.montant, TP.idpartenaire HAVING
(((Count(*))>1))
EXPR1 IDMEMBRE MONTANT IDPARTENAIRE
----------- ----------- ------------------------ ------------
4 12 +3,60000000000000E+001 31
1 record(s) selected.
CONNECT RESET
DB20000I The SQL command completed successfully.
Partager