As On A Date query

From: abhilash <abhilashbabu_at_gmail.com>
Date: 1 Apr 2005 03:42:59 -0800
Message-ID: <21b78daf.0504010342.3ec10530@posting.google.com>

Hello friends

Suppose in a table i have records like this. ( I am using Oracle 9.2)

Ac_No Date Balance

---

101   1/1/2005     1000
101   5/1/2005     1500

101 15/1/2005 2500
101 30/1/2005 1800

---

Each time a change occurs in the account a record is inserted into the table. This means the party maintained balance of 1000 from 1 to 4 th. How can i find balance as on 10/1/2005 (which is 1500) without using full table scan. It can be found using rank or other analytical function but requires full table scan.

Regards
Abhilash Received on Fri Apr 01 2005 - 05:42:59 CST