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 -> Efficient SQL statement needed

Efficient SQL statement needed

From: Bjørn Sindre Slåtto <bsl_at_provida.no>
Date: Thu, 25 Jun 1998 16:14:47 +0200
Message-ID: <35924d14.0@news.provida.no> 





Is is possible to summarise field A grouped by field B but with the newest
record excluded within each group (field C contains the date YYYYMMDD)?



This SQL statement has to take care of 600 000 records.


Received on Thu Jun 25 1998 - 09:14:47 CDT












Original text of this message













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