Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> distinct

distinct

From: Andrea <andrea75_at_yahoo.de>
Date: Thu, 8 Apr 2004 16:46:46 +0200
Message-ID: <c53okp$2of6a5$1@ID-98178.news.uni-berlin.de> 





Hi,



I have the following SQL



"SELECT  TRUNC(datetime) FROM  table1 WHERE object_nr=1 AND datetime BETWEEN
('01.01.2004') AND ('18.03.2004') AND value BETWEEN 1.5 AND 7.5 ORDER BY
datetime"



I am getting multiple rows for the same date. Using of  "SELECT DISTINCT
TRUNC(...." I get


ORA-01791.



Any solutions to this problem?



Regards


Andrea
Received on Thu Apr 08 2004 - 09:46:46 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US