Re: SQL to detect when a record was entered
From: Thomas Blankschein <thomas_at_blankschein.de>
Date: Thu, 21 May 2009 15:28:24 +0200
Message-ID: <4a1556f8$0$31343$9b4e6d93_at_newsspool4.arcor-online.net>
It seems I need to compare the last record to the second last
> record. Is this even possible?
Date: Thu, 21 May 2009 15:28:24 +0200
Message-ID: <4a1556f8$0$31343$9b4e6d93_at_newsspool4.arcor-online.net>
It seems I need to compare the last record to the second last
> record. Is this even possible?
Check out analytic functions, especially LAG() and LEAD(). At asktom.oracle.com you will find several threads about this, including clear examples from Tom. Received on Thu May 21 2009 - 08:28:24 CDT