A voir également:
- SQL Problème de In et not in
- Navigation in private - Guide
- Deco in paris avis ✓ - Forum Consommation & Internet
- Rf in - Forum Téléviseurs
- Dc in - Forum Disque dur / SSD
- Playback error reconnect in 3s (1/5) francais - Forum Box et Streaming vidéo
1 réponse
Bonsoir
Requete suivante OK en 0.0627 sec
SELECT t2.*
FROM user as t1, user as t2
WHERE (t1.date='04/03/2004'
AND t2.code=t1.code
AND t2.date=t1.date)
OR (t2.date='05/03/2004'
AND t2.code=t1.code
AND t2.date!=t1.date);
Requete suivante OK en 0.0572 sec
SELECT t2.*
FROM user as t1, user as t2
WHERE (t1.date='04/03/2004'
AND t2.code=t1.code
AND t2.date=t1.date)
OR (t2.date='05/03/2004'
AND t2.code=t1.code
AND t1.date='04/03/2004');
Requete suivante OK en 0.0040 sec
SELECT t2.*
FROM user as t1, user as t2
WHERE t1.date='04/03/2004'
AND t2.code=t1.code
AND (t2.date=t1.date
OR t2.date='05/03/2004');
La 3e est 15 fois plus rapide.
Requete suivante OK en 0.0627 sec
SELECT t2.*
FROM user as t1, user as t2
WHERE (t1.date='04/03/2004'
AND t2.code=t1.code
AND t2.date=t1.date)
OR (t2.date='05/03/2004'
AND t2.code=t1.code
AND t2.date!=t1.date);
Requete suivante OK en 0.0572 sec
SELECT t2.*
FROM user as t1, user as t2
WHERE (t1.date='04/03/2004'
AND t2.code=t1.code
AND t2.date=t1.date)
OR (t2.date='05/03/2004'
AND t2.code=t1.code
AND t1.date='04/03/2004');
Requete suivante OK en 0.0040 sec
SELECT t2.*
FROM user as t1, user as t2
WHERE t1.date='04/03/2004'
AND t2.code=t1.code
AND (t2.date=t1.date
OR t2.date='05/03/2004');
La 3e est 15 fois plus rapide.