Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
HAVING phrase
Message
From
11/06/2008 09:55:01
 
 
To
11/06/2008 09:35:26
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
01323049
Message ID:
01323071
Views:
16
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform