Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using having without group by
Message
From
24/12/2000 04:20:56
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Using having without group by
Miscellaneous
Thread ID:
00456657
Message ID:
00456657
Views:
71
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
Next
Reply
Map
View

Click here to load this message in the networking platform