随机读取数据库中某条信息的SQL语句写法

最新推荐文章于 2021-02-08 15:29:57 发布

lfywy

最新推荐文章于 2021-02-08 15:29:57 发布

阅读量799

点赞数

文章标签：数据库 sql build date

本文链接：https://blog.csdn.net/lfywy/article/details/3453863

版权

随机读取数据库中某条信息的SQL语句写法：以备日后使用！

SELECT     TOP (1) OBJECTID, DRAI_PUMP_ID, SYS_ID, DRAI_PUMP_NAME, DRAI_PUMP_TYPE, DRAI_PUMP_TYPE_FEAT, DRAI_PUMP_ADD,
                      DRAI_PUMP_PHONE, DRAI_PUMP_POST_CODE, DRAI_PUMP_STATE, RingRoad, DRAI_PUMP_COM_DSN, DRAI_PUMP_COM_BUILD,
                      DRAI_PUMP_COM_MNG, MaintainsUnit, FinishDate, RunDate, ReBuildDate, DRAI_PUMP_FLOW_DSN_Y, DRAI_PUMP_FLOW_DSN_W,
                      DRAI_PUMP_FLOW_FACT_Y, DRAI_PUMP_FLOW_FACT_W, DRAI_PUMP_POW_DSN_Y, DRAI_PUMP_POW_DSN_W, DRAI_PUMP_POW_FACT_Y,
                      DRAI_PUMP_POW_FACT_W, DRAI_PUMP_POW_SUM_Y, DRAI_PUMP_POW_SUM_W, DRAI_PUMP_LEVEL_DSN_Y, DRAI_PUMP_LEVEL_DSN_W,
                      DRAI_PUMP_LEVEL_MAX_Y, DRAI_PUMP_LEVEL_MAX_W, DRAI_PUMP_LEVEL_MIN_Y, DRAI_PUMP_LEVEL_MIN_W, DRAI_PUMP_AREA_USE,
                      DRAI_PUMP_PLAN, DRAI_PUMP_PROFILE, GrillPlatX, GrillPlatY, GrillPlatElev, GroundElev, DesRainstormReP, DesCoefficient, ServiceRange,
                      ServiceArea, DRAI_PUMP_TO_RIV, Outlet_Id, MapSheetId, IsUse, In_Com, In_Date, In_Use, VersionId, Remark, KEY_ID, Shape
FROM         sde.tDrai_Pump_St
ORDER BY NEWID()