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

Home -> Community -> Usenet -> c.d.o.server -> Re: SQL - Combine multiple records to give 1 record

Re: SQL - Combine multiple records to give 1 record

From: Rene Nyffenegger <rene.nyffenegger_at_gmx.ch>
Date: Sat, 27 Aug 2005 01:03:33 +0000 (UTC)
Message-ID: <deoe55$qfs$2@klatschtante.init7.net> 





On 2005-08-26, premgoel_at_gmail.com <premgoel_at_gmail.com> wrote:


> This is basically to track the period for which the patient was taking

> a drug. The patients fills a prescription before the previous one

> finishes. So the patient is on the same drug withourt interruption.




Look into the analytical function lag().



hth


Rene



-- 
  Rene Nyffenegger
  http://www.adp-gmbh.ch/


Received on Fri Aug 26 2005 - 20:03:33 CDT












Original text of this message













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