Re: SQL Problem

Are we solving your homework assignment??

break on m_date
Select T2.m_date, T1.id, T1.amount
  from A T1, A T2
  where T1.m_date >= T2.m_date;

In article <7oqm69$bqp$1_at_nnrp1.deja.com>, Agi <agichen_at_my-deja.com> wrote:
>Hello,everyone
> I have a table(A) data like follows
>
> id m_date amount
> --- ------- ---------
> 1 1-Aug-99 1000
> 2 2-Aug-99 2000
> 3 3-Aug-99 3000
> 4 4-Aug-99 4000
> 5 5-Aug-99 5000
>
>
>Now,I have the problem about the SQL statement to get results as follows
>
> m_date id amount
> -------- --- --------
> 1-Aug-99 1 1000 /* m_date >='1-Aug-99' in A*/
> 2 2000
> 3 3000
> 4 4000
> 5 5000
> 2-Aug-99 2 2000 /* m_date >='2-Aug-99' in A*/
> 3 3000
> 4 4000
> 5 5000
> 3-Aug-99 3 3000
> 4 4000
> 5 5000
> 4-Aug-99 4 4000
> 5 5000
> 5-Aug-99 5 5000
>
> Any hint ??
>
>Rgds,
>Agi
Received on Wed Aug 11 1999 - 06:15:16 CEST