SQL Problem

[Quoted]    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

[Quoted]    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. Received on Wed Aug 11 1999 - 04:12:32 CEST