Re: Inner Join using datetime columns, Performance Issues
Posted by:
Rick James
Date: January 31, 2014 05:34PM
SHOW CREATE TABLE -- for each table.
> SELECT start.servicecheck, start.datetime ... GROUP BY start.datetime
Which servicecheck do you want it to provide? It will give you a random one. What do you really want? The first one? The last one? If there is only one per datetime, then GROUP BY it, too.
Subject
Written By
Posted
Re: Inner Join using datetime columns, Performance Issues
January 31, 2014 05:34PM
February 04, 2014 02:02AM
February 04, 2014 09:50AM
February 04, 2014 03:10PM
February 06, 2014 07:00AM
February 06, 2014 02:51PM
February 06, 2014 07:32PM
February 10, 2014 07:53AM
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.