Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>Using having without group by
>
>Is it OK to use having without group by in SQL SELECT ?
>
>I want to place additional filter to result columns,
>like:
>
>Select ;
> as myvalue, ;
> from mytable ;
> having betw( myvalue, 1,100 )
>
> is a very complex expression and i don't wish to include it to having clause second time.
This is from Help:
A HAVING clause without a GROUP BY clause acts like a WHERE clause. You can use local aliases and field functions in the HAVING clause. Use a WHERE clause for faster performance if your HAVING clause contains no field functions. Note that the HAVING clause should appear before an INTO clause or a syntax error occurs.
Mark
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement