Re: Help needed in SQL Query
From: Surendra <surendramuthye_at_yahoo.com>
Date: 18 Aug 2003 10:22:23 -0700
Message-ID: <742a5eb5.0308180922.fbc759c_at_posting.google.com>
Date: 18 Aug 2003 10:22:23 -0700
Message-ID: <742a5eb5.0308180922.fbc759c_at_posting.google.com>
LKBrwn_DBA <member30625_at_dbforums.com> wrote in message news:<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;
Thank you very much. This definitely gives me the result that I was looking for. Received on Mon Aug 18 2003 - 19:22:23 CEST