Need help with SQL

From: Philip Kuan <philipkuan_at_hotmail.com>
Date: 11 Jul 2002 13:20:13 -0700
Message-ID: <9621f3f0.0207111220.6f6c8677@posting.google.com>

Hi All,

We are using Oracle 8.

I have a table like this:

Ernty_Time

---

7/1/2002
7/3/2002
7/4/2002
7/8/2002
7/9/2002
7/11/2002

The query results should look like this:

Entry_Time     Value (next entry_time - previous entry_time)


----------     -----

7/1/2002        2
7/3/2002        1
7/4/2002        4
7/8/2002        1
7/9/2002        2

7/11/2002

Since we are using Oracle 8 I cannot use LEAD analytic function provided in 8i and 9i. There is no ID column as well.

I appreciate any help. Thank you in advance.

Philip Kuan Received on Thu Jul 11 2002 - 15:20:13 CDT