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
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
On Wed, Jan 15, 2014 at 4:06 PM, shawn l.green wrote:
> Hello Larry,
>
>
> On 1/13/2014 2:43 AM, Peter Brawley wrote:
>>
>>
>> On 2014-01-12 9:13 PM, Larry Martell wrote:
>>>
>>> On Sun, Jan 12, 2014 at 2:47 PM, Peter Brawley
>>> wrote:
On 2014-01-12 1:17 PM, Larry Martell wrote:
>
Hello Larry,
On 1/13/2014 2:43 AM, Peter Brawley wrote:
On 2014-01-12 9:13 PM, Larry Martell wrote:
On Sun, Jan 12, 2014 at 2:47 PM, Peter Brawley
wrote:
On 2014-01-12 1:17 PM, Larry Martell wrote:
I've been asked to do something that I do not think is possible in SQL.
I have a query that
On Mon, Jan 13, 2014 at 2:43 AM, Peter Brawley
wrote:
>
> On 2014-01-12 9:13 PM, Larry Martell wrote:
>>
>> On Sun, Jan 12, 2014 at 2:47 PM, Peter Brawley
>> wrote:
>>>
>>> On 2014-01-12 1:17 PM, Larry Martell wrote:
I've been asked to do something that I do not think is possible in SQL
On 2014-01-12 9:13 PM, Larry Martell wrote:
On Sun, Jan 12, 2014 at 2:47 PM, Peter Brawley
wrote:
On 2014-01-12 1:17 PM, Larry Martell wrote:
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), C
On Sun, Jan 12, 2014 at 2:47 PM, Peter Brawley
wrote:
> On 2014-01-12 1:17 PM, Larry Martell wrote:
>>
>> 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
On 2014-01-12 1:17 PM, Larry Martell wrote:
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.218,
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.218, 2213.949 or
10053.490, 2542.094).
The busine
