Discussion :

[[ZiP]]

Bonjour,

Voici ma requête :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
 
SELECT num, SUM(freq) FROM (
SELECT numero1 AS num, COUNT(numero1) AS freq FROM tirages GROUP BY numero1 UNION ALL
SELECT numero2 AS num, COUNT(numero2) AS freq FROM tirages GROUP BY numero2 UNION ALL
SELECT numero3 AS num, COUNT(numero3) AS freq FROM tirages GROUP BY numero3 UNION ALL
SELECT numero4 AS num, COUNT(numero4) AS freq FROM tirages GROUP BY numero4 UNION ALL
SELECT numero5 AS num, COUNT(numero5) AS freq FROM tirages GROUP BY numero5 UNION ALL
SELECT numero6 AS num, COUNT(numero6) AS freq FROM tirages GROUP BY numero6
) tirage GROUP BY num ORDER BY SUM(freq) DESC,num ASC;

Je n'arrive pas à utiliser AS comme avec MySQL :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
 
SELECT num AS numero, SUM(freq) AS frequence FROM (
SELECT numero1 AS num, COUNT(numero1) AS freq FROM tirages GROUP BY numero1 UNION ALL
SELECT numero2 AS num, COUNT(numero2) AS freq FROM tirages GROUP BY numero2 UNION ALL
SELECT numero3 AS num, COUNT(numero3) AS freq FROM tirages GROUP BY numero3 UNION ALL
SELECT numero4 AS num, COUNT(numero4) AS freq FROM tirages GROUP BY numero4 UNION ALL
SELECT numero5 AS num, COUNT(numero5) AS freq FROM tirages GROUP BY numero5 UNION ALL
SELECT numero6 AS num, COUNT(numero6) AS freq FROM tirages GROUP BY numero6
) tirage GROUP BY numero ORDER BY frequence DESC,numero ASC;

Savez-vous si c'est possible ?

Si, oui, comment procéder ?

Merci,
ZiP

[Chtulus]

Bonjour,


N'utilisez pas les noms d'alias mais vos noms de colonne.

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
 
SELECT num AS numero, SUM(freq) AS frequence FROM (
...) tirage 
GROUP BY num 
ORDER BY SUM(freq) DESC, 
              num ASC

[[ZiP]]

C'est effectivement ce que j'ai fini par faire.

Merci,
ZiP