Jan Theodore,
The schemas and data-sample are attached.
I need view the last int_key row grouped by int_phonecall_key.
Tks
Daniel
----- Original Message -----
From: "Jan Theodore Galkowski" <jtgalkowski@stripped>
To: "Daniel Bronzeri Barbosa" <daniel@stripped>; "Daniel Bronzeri
Barbosa" <daniel@stripped>
Cc: <win32@stripped>
Sent: Tuesday, December 14, 2004 3:17 PM
Subject: [BRMA-ALTO-RISCO] Re: [BRMA-ALTO-RISCO] Re: [BRMA-ALTO-RISCO] Re:
Help in Subquerys...
Please send or post schemas for the tables involved, thanks.
I can get back to you on it by end of day, Eastern Time, USA.
-jtg
On Tue, 14 Dec 2004 15:47:15 -0300, "Daniel Bronzeri Barbosa"
<daniel@stripped> said:
> An aditional information,
> this query
>
> SELECT max(int_key)
> FROM tbl_hlt_phonecall_historicaldata
> GROUP by int_phonecall_key
>
> Returns 2 rows
>
> int_key
> 184
> 188
>
> tks
>
> Daniel
>
> ----- Original Message -----
> From: "Daniel Bronzeri Barbosa" <daniel@stripped>
> To: "Jan Theodore Galkowski" <jtgalkowski@stripped>
> Cc: <win32@stripped>
> Sent: Tuesday, December 14, 2004 3:40 PM
> Subject: [BRMA-ALTO-RISCO] Re: [BRMA-ALTO-RISCO] Re: Help in Subquerys...
>
>
> Jan Theodore,
>
> This query don't running too
>
> SELECT *
> FROM tbl_hlt_phonecall_historicaldata
> WHERE int_key =
> (
> SELECT max(int_key)
> FROM tbl_hlt_phonecall_historicaldata
> GROUP by int_phonecall_key
> )
>
> tks,
>
> Daniel
>
> ----- Original Message -----
> From: "Jan Theodore Galkowski" <jtgalkowski@stripped>
> To: "Daniel Bronzeri Barbosa" <daniel@stripped>
> Sent: Tuesday, December 14, 2004 2:25 PM
> Subject: [BRMA-ALTO-RISCO] Re: Help in Subquerys...
>
>
> Well, Daniel, for one thing the SQL syntax isn't right. Try:
>
> ... WHERE int_key = (select max(int_key) from ...
>
> -jtg
>
> On Tue, 14 Dec 2004 15:24:55 -0300, "Daniel Bronzeri Barbosa"
> <daniel@stripped> said:
> > People,
> >
> > How can I run this query in MySQL 4.0???
> >
> > SELECT *
> > FROM `tbl_hlt_phonecall_historicaldata`
> > WHERE int_key in
> > (
> > select max(int_key)
> > from tbl_hlt_phonecall_historicaldata
> > group by int_phonecall_key
> > )
[snip]
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=1
