Halo para pakar Oracle Indonesia,

Saya beginner di oracle, dan sekarang sedang coba2 utk bermain sql command.

Ada bbrp yg ingin saya tanyakan. Asumsi :

 

Database.

 

Tgl_Jual                Shift                       Total_Shift

----------------------------------------------------

01/01/2008         1                              10.000   

01/01/2008         2                              20.000   

02/01/2008         1                              15.000   

02/01/2008         2                              30.000   

03/01/2008         1                              20.000   

03/01/2008         2                              40.000   

 

 

 

SQL Output

Tgl_Jual                Shift_1                  Shift_2
Total

------------------------------------------------------------------

01/01/2008         10.000                   20.000                   30.000

02/01/2008         20.000                   30.000                   50.000

03/01/2008         20.000                   40.000                   60.000

 

Mohon pencerahannya.

 

Terimakasih,

 

Ferdinand

 

 

 

 

 



[Non-text portions of this message have been removed]

Kirim email ke