MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: Tunning or optimizing a query
Posted by: David Fells
Date: April 05, 2005 07:42AM

EXPLAIN SELECT t.ranum, t.serloc, t.timeanddate
FROM transtable t,
(SELECT ranum, MAX(timeanddate) AS MAX_DATE FROM transtable WHERE ranum NOT LIKE '%AC' GROUP BY ranum)
WHERE t.ranum = b.ranum AND t.timeanddate = b.MAX_DATE AND t.serloc NOT LIKE '5410179601'

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Tunning or optimizing a query
Mike Henderson
April 05, 2005 07:16AM
Re: Tunning or optimizing a query
David Fells
April 05, 2005 07:42AM
Re: Tunning or optimizing a query
Mike Henderson
April 05, 2005 08:52AM
Re: Tunning or optimizing a query
David Fells
April 05, 2005 02:15PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.