Re: SQL query
This is a discussion on Re: SQL query within the Sybase forums, part of the Database Server Software category; --> search google for "characteristic functions" "AK" <ak.fuan@uk.mizuho-sc.com> wrote in message news:51586da.0307040545.26f3cf0e@posting.google.co m... > I have got a table which ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-08-2008, 02:40 PM
| ||||
| ||||
 Re: SQL query search google for "characteristic functions" "AK" <ak.fuan@uk.mizuho-sc.com> wrote in message news:51586da.0307040545.26f3cf0e@posting.google.co m... > 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      |
Linear Mode
