Re: SQL Problem

I've done it !!

Thanks !!

(PS. It's not a homework assignment, I just try to know a different way   to solve problem.)

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
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Aug 11 1999 - 06:49:45 CEST