Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
HAVING phrase
Message
De
11/06/2008 09:55:01
 
 
À
11/06/2008 09:35:26
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
01323049
Message ID:
01323071
Vues:
17
>So ... Having 2 # 0
>
>????

Sorry, that was a dumb answer. Position works in GROUP BY and ORDER BY. I don't see a solution other than using a different field name. However, if it's important to have the specified field name in the result, do the grouping/having in a derived table and rename the field in the result:

SELECT a as a, b as b, q as c, ... ;
FROM (SELECT ..., whatever as q .... HAVING q>5)

Tamar
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform