Path: news.cambrium.nl!textnews.cambrium.nl!feeder3.cambriumusenet.nl!feed.tweaknews.nl!postnews.google.com!f20g2000prn.googlegroups.com!not-for-mail From: Raju Angani Newsgroups: comp.databases.oracle.server,comp.databases.oracle.misc Subject: Re: help on sql Date: Fri, 9 Oct 2009 23:41:43 -0700 (PDT) Organization: http://groups.google.com Lines: 20 Message-ID: References: <2668891e-369b-4fe1-a9d9-86fbddc63614@o41g2000yqb.googlegroups.com> NNTP-Posting-Host: 98.234.68.230 Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 X-Trace: posting.google.com 1255156904 27027 127.0.0.1 (10 Oct 2009 06:41:44 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Sat, 10 Oct 2009 06:41:44 +0000 (UTC) Complaints-To: groups-abuse@google.com Injection-Info: f20g2000prn.googlegroups.com; posting-host=98.234.68.230; posting-account=PUGg3woAAAAm1Iv3W7osH1ERMcX9Urnt User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.3) Gecko/20090824 Firefox/3.5.3 GTB5 (.NET CLR 3.5.30729),gzip(gfe),gzip(gfe) Xref: news.cambrium.nl comp.databases.oracle.server:100960 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