Re: SELECT Records using multiple ciritria
> The query works but returns the wrong average.
It's correct for the sample data you posted. If you have a dataset for which the query is incorrect, post the dataset as a set of Insert statements we can work with.
The latest query you posted implies your `date` column is misnamed, it's a datetime or timestamp column. So we waste no more time and effort on guesses, please post the result of how Create Table for the table.
Subject
Written By
Posted
Re: SELECT Records using multiple ciritria
October 31, 2016 11:51AM
November 01, 2016 04:14AM
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.