2006-12-28

MAPINFO MAPBASIC語法

Select sum(Area(obj, "sq km")) from case6_floodg where z>=3 and z<10
into case6_floodg1
Select sum(Area(obj, "sq km")) from case6_floodg where z>=1 and z<3
into case6_floodg2
Select sum(Area(obj, "sq km")) from case6_floodg where z>=0.5 and z<1
into case6_floodg3
Select sum(Area(obj, "sq km")) from case6_floodg where z>=0.3 and
z<0.5 into case6_floodg4
Select sum(Area(obj, "sq km")) from case6_floodg where z>0 and z<0.3
into case6_floodg5
Browse * From case6_floodg1
Browse * From case6_floodg2
Browse * From case6_floodg3
Browse * From case6_floodg4
Browse * From case6_floodg5
可簡化查詢動作

沒有留言:

張貼留言

Q80 和 Q90

  "Q80" 和 "Q90" 是與水位(水流量)相關的術語,通常用於水文學和水資源管理領域。這些術語涉及在不同的情境下對水位和水流量進行推估和應用。 1. Q80 和 Q90 定義:    - Q80:在某段特定的時間內,80% 的時間水...