Re: SQL query

#1

search google for "characteristic functions"

"AK" <ak.fuan (AT) uk (DOT) mizuho-sc.com> wrote

Quote:

I have got a table which contains the following column and data.

DateField Amount
01/01/03 5
02/01/03 10
03/01/03 10
04/01/03 10
05/01/03 13
06/01/03 5
07/01/03 5
08/01/03 30
09/01/03 10
10/01/03 10
11/01/03 30

How do I retrieve the following values without the use of cursor or
doing row based processing.

DateField Amount
01/01/03 5
04/01/03 10 (the max date for this value before it changes to
13.)
05/01/03 13
07/01/03 5 (the max date for this value before it changes to
13.)
08/01/03 30
10/01/03 10 (the max date for this value before it changes to
13.)
11/01/03 30

Regards
AK

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: SQL query

comp.databases.sybase comp.databases.sybase

Re: SQL query - 07-04-2003 , 03:28 PM