当前位置: 代码迷 >> Oracle管理 >> oracle的查询语句
  详细解决方案

oracle的查询语句

热度:73   发布时间:2016-04-24 04:21:52.0
求一个oracle的查询语句
有两张表,
ads_box:字段:boxid,              ads_thing:字段:boxid,
                                name,                                             num,
                                 .......                                                time,
                                
box表的boxid是唯一的,而thing表以boxid和time为主键,boxid不唯一。
ads_box: boxid               name                     ads_thing:       boxid                 num                   time
                      1                 test1                                                           1                 1.10            2013-01-01 00:00:00
                      2                 test2                                                           1                  2.10           2013-01-01 00:30:00
                           .......                                                                           1                  3.81           2013-01-02 00:30:00
                                                                                                              2                                    2013-01-01 00:30:00
                                                                                                              2                                    2013-01-02 01:30:00
  相关解决方案