 | | | Re: Help in Subquerys... | Re: Help in Subquerys... 2004-12-14 - By Daniel Bronzeri Barbosa
Back
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@(protected)>
To: "Daniel Bronzeri Barbosa" <daniel@(protected)>
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@(protected)> 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]
--
Jan Theodore Galkowski (o??)
jtgalkowski@(protected)
http://www.smalltalkidiom.net
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=mysql@(protected)
Earn $52 per hosting referral at Lunarpages.
|
|
|