For me, it seems just use [case - when ] on the difference between x and y, and
group by with output.
Good luck *\(^o^)/*
Sent from my iPhone
On Jan 21, 2014, at 15:38, h...@tbbs.net wrote:
> 2014/01/12 14:17 -0500, Larry Martell
> I've been asked to do something that I do not think
I like Latin1. I set up my version 5.5 to use it by default, but sometimes it
changed Client & Connection characterset to UTF8.
Now I have 5.6, and the client comes up with Client & Connection characterset
CP850 (CP850 is the Swedish variant of CP437, the IBM PC s original character
set). Why??
2014/01/12 14:17 -0500, Larry Martell
I've been asked to do something that I do not think is possible in SQL.
I have a query that has this basic form:
SELECT a, b, c, d, AVG(e), STD(e), CONCAT(x, ',', y) as f
FROM t
GROUP BY a, b, c, d, f
x and y are numbers (378.18, 2213.797 or 378.21
