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.
Andrus