oracle 11g SQL :help for a complicated sql query
I need help... For example i have this table..
acc_num open close activate date
------- ---- ----- -------- ----------
200 1 0 0 2013/01/01
200 0 1 0 2013/01/10
200 0 0 1 2013/01/12
The output should be:
acc_num open_date act_date close_date
200 2013/01/01 2013/01/10 2013/01/10
Thanks for your help
No comments:
Post a Comment