Home -> Usenet -> c.d.o.misc -> Re: help on sql

Re: help on sql

From: Raju Angani <angani_at_gmail.com>
Date: Fri, 9 Oct 2009 23:41:43 -0700 (PDT)
Message-ID: <d069a254-6d25-474b-a7ac-c73186676194_at_f20g2000prn.googlegroups.com> 





Sorry for the messup



Sample Data



insert into find_fixed_open values(5,3,2,'10/01/2009');
insert into find_fixed_open values(52,38,14,'10/02/2009');
insert into find_fixed_open values(68,45,23,'10/03/2009');
insert into find_fixed_open values(112,59,53,'10/04/2009');
insert into find_fixed_open values(45,12,33,'10/05/2009');





Output should look like this




'10/01/2009',5,3,2

'10/02/2009',52,38,16

'10/03/2009',68,45,39

'10/04/2009',112,59,92

'10/05/2009',45,12,125




thanks


Raju
Received on Sat Oct 10 2009 - 01:41:43 CDT












Original text of this message