Click here to Skip to main content
15,922,650 members

Comments by BikliWe Wiyao ALI (Top 3 by date)

BikliWe Wiyao ALI 10-Nov-18 16:33pm View    
Deleted
1. " Every field in your select statement that you are not performing an aggregate function on (Sum, Avg, Max, etc) must be listed in the Group By clause", that I understood
2." the Group By does not allow field aliases, you should use the actual field name there. gives me an "field not bounded error" since it is not in the subquery(inner query)
3. Referencing "my" and "grouping on it" as gives me the first array as I already stated. Can you provide an example code to answer my question
BikliWe Wiyao ALI 10-Nov-18 16:29pm View    
The provided link does not outline my question. Can you give me a sample code from my question to resolve the issue
BikliWe Wiyao ALI 10-Nov-18 16:24pm View    
1."Every field in your select statement that you are not performing an aggregate function on (Sum, Avg, Max, etc) must be listed in the Group By clause", that I understood.
2."the Group By does not allow field aliases, you should use the actual field name there." by doing so, it gives me field not bounded error since( it is in outer query)
3."..all you need to do is reference the 'my' alias for your user in the outside query, then remember to group on it". Like I said grouping on "my" gives me more that I need to return as in the first array. Unless I am not getting you can you suggest an example code