Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
GroupBy expression not compliant with VFP
Message
 
 
To
12/03/2008 11:30:43
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Miscellaneous
Thread ID:
01301191
Message ID:
01301337
Views:
17
>>BTW, this query doesn't make much sense. There should be other fields here or you can use DISTINCT instead.
>
>That's all there is. Why do you say there should be more fields?
select Field1, Field2 .. group by Field1, Field2
is the same as
select distinct Field1, Field2
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform