Home -> Usenet -> comp.databases.oracle -> Re: Help needed in SQL Query

Re: Help needed in SQL Query

From: LKBrwn_DBA <member30625_at_dbforums.com>
Date: Tue, 12 Aug 2003 22:23:22 +0000
Message-ID: <3231459.1060727002_at_dbforums.com> 








Try this (for Oracle 8i+):



Select Grp_Code, End_Date,


Rank() Over(Partition By Grp_Code Order By End_Date) As Sq
From The_Table Group By Grp_Code, End_Date;


--
Posted via http://dbforums.com


Received on Wed Aug 13 2003 - 00:23:22 CEST












Original text of this message