Changes between Version 10 and Version 11 of oid/WorkLog/09-02-05
- Timestamp:
- Feb 5, 2009, 8:57:02 PM (16 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
oid/WorkLog/09-02-05
v10 v11 79 79 }}} 80 80 * 現有資料經緯度範圍 81 {{{SELECT max( loc1_lon ) , max( loc1_lat ) , max( loc2_lon ) , max( loc2_lat ) , min( loc1_lon ) , min( loc1_lat ) , min( loc2_lon ) , min( loc2_lat ) 81 {{{ 82 SELECT max( loc1_lon ) , max( loc1_lat ) , max( loc2_lon ) , max( loc2_lat ) , min( loc1_lon ) , min( loc1_lat ) , min( loc2_lon ) , min( loc2_lat ) 82 83 FROM maincase_new 83 84 WHERE loc1_lon >0 AND loc1_lat >0