I
Sent from my D
- Reply message -
From: "Rick James"
To: "Larry Martell" , "shawn green"
Cc: "mysql mailing list"
Subject: Problem with having
Date: Thu, Sep 26, 2013 12:11 PM
Still more to this saga
Comment 1:
... HAVING x;
The expre
; -Original Message-
> From: Larry Martell [mailto:larry.mart...@gmail.com]
> Sent: Tuesday, September 24, 2013 1:44 PM
> To: shawn green
> Cc: mysql mailing list
> Subject: Re: Problem with having
>
> On Tue, Sep 24, 2013 at 9:05 AM, shawn green
> wrote:
>
> &
On Tue, Sep 24, 2013 at 9:05 AM, shawn green wrote:
> Hello Larry,
>
>
> On 9/23/2013 6:22 PM, Larry Martell wrote:
>
>> On Mon, Sep 23, 2013 at 3:15 PM, shawn green **
>> wrote:
>>
>> Hi Larry,
>>>
>>>
>>> On 9/23/2013 3:58 PM, Larry Martell wrote:
>>>
>>> On Mon, Sep 23, 2013 at 1:51 PM, Sukhj
Hello Larry,
On 9/23/2013 6:22 PM, Larry Martell wrote:
On Mon, Sep 23, 2013 at 3:15 PM, shawn green wrote:
Hi Larry,
On 9/23/2013 3:58 PM, Larry Martell wrote:
On Mon, Sep 23, 2013 at 1:51 PM, Sukhjinder K. Narula
wrote:
Hi,
In your second query, you seem to have MIN(date_time), but
On Mon, Sep 23, 2013 at 2:17 PM, Sukhjinder K. Narula
wrote:
> Hi,
>
> I see that. So the query seems to be picking the first entry out of the
> after grouping by a field and displaying it. And it seems to make sense
> since Having clause seems incomplete. I believe we need to complete the
> condi
On Mon, Sep 23, 2013 at 3:15 PM, shawn green wrote:
> Hi Larry,
>
>
> On 9/23/2013 3:58 PM, Larry Martell wrote:
>
>> On Mon, Sep 23, 2013 at 1:51 PM, Sukhjinder K. Narula
>> wrote:
>>
>> Hi,
>>>
>>> In your second query, you seem to have MIN(date_time), but you are
>>> talking about maximum. So
select recipe_id,max(maxdatetime) from data_csmeta group by recipe_id
having recipe_id=19166;
On Mon, Sep 23, 2013 at 4:15 PM, shawn green wrote:
> Hi Larry,
>
>
> On 9/23/2013 3:58 PM, Larry Martell wrote:
>
>> On Mon, Sep 23, 2013 at 1:51 PM, Sukhjinder K. Narula
>> wrote:
>>
>> Hi,
>>>
>>> I
Hi Larry,
On 9/23/2013 3:58 PM, Larry Martell wrote:
On Mon, Sep 23, 2013 at 1:51 PM, Sukhjinder K. Narula
wrote:
Hi,
In your second query, you seem to have MIN(date_time), but you are
talking about maximum. So your group by query is actually pulling the
minimum date for this recipe.
I pas
On Mon, Sep 23, 2013 at 1:51 PM, Sukhjinder K. Narula
wrote:
> Hi,
>
> In your second query, you seem to have MIN(date_time), but you are
> talking about maximum. So your group by query is actually pulling the
> minimum date for this recipe.
>
I pasted the wrong query in. I get the same results r
I want to find the rows from a table that have the max date_time for each
recipe. I know I've done this before with group by and having, but I can't
seem to get it to work now. I get the correct row id, but not the correct
date_time. I'm sure I'm missing something simple.
For purposes of showing a
Hi,
In your second query, you seem to have MIN(date_time), but you are talking
about maximum. So your group by query is actually pulling the minimum date
for this recipe.
Regards.
On Mon, Sep 23, 2013 at 3:35 PM, Larry Martell wrote:
> I want to find the rows from a table that have the max date
Hi,
I'm running Mysql 4.01 on mandrake 8.2 with all production data
using InnoDB type.
I've a field named "dch_pri" contain some account transaction data in
format of DECIMAL (14,2).
When running following query:
SELECT din_no, SUM(IF(tran_type = "D", dch_pri, -dch_pri)) AS dch_sum
12 matches
Mail list logo
