General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only