Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!g14g2000cwa.googlegroups.com!not-for-mail From: "vikas.chahal@gmail.com" Newsgroups: comp.databases.oracle.misc Subject: Re: help in writing an sql Date: 2 Feb 2005 07:22:21 -0800 Organization: http://groups.google.com Lines: 12 Message-ID: <1107357741.271425.223300@g14g2000cwa.googlegroups.com> References: NNTP-Posting-Host: 148.87.1.170 Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-Trace: posting.google.com 1107357745 17249 127.0.0.1 (2 Feb 2005 15:22:25 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Wed, 2 Feb 2005 15:22:25 +0000 (UTC) In-Reply-To: User-Agent: G2/0.2 Complaints-To: groups-abuse@google.com Injection-Info: g14g2000cwa.googlegroups.com; posting-host=148.87.1.170; posting-account=aem9Hg0AAAD7iJg-fGUcdgrWFsYZP-SO Xref: dp-news.maxwell.syr.edu comp.databases.oracle.misc:116131 can u be pls specific as to what out of the result u want if the data is stored with three rows of same date like sch_date sch_week sch_act -------- -------- ------- 02-Jan-05 1 X 02-Jan-05 1 Y 02-Jan-05 1 X or Z 04-Jan-05 1 X 05-Jan-05 1 Y