随笔-103  评论-37  文章-0  trackbacks-0
select NeConfig.NeName,SystemPerformance.ID,SystemPerformance.Time,PerfThreshold.PerfID,SystemPerformance.CpuUseRatio as Performance,PerfThreshold.HighWatermark from NeConfig,SystemPerformance,PerfThreshold where PerfThreshold.PerfID=1 union select NeConfig.NeName,SystemPerformance.ID,SystemPerformance.Time,PerfThreshold.PerfID,SystemPerformance.CpuTemp as Performance,PerfThreshold.HighWatermark from NeConfig,SystemPerformance,PerfThreshold where PerfThreshold.PerfID=2 union select NeConfig.NeName,SystemPerformance.ID,SystemPerformance.Time,PerfThreshold.PerfID,SystemPerformance.MemUseRatio as Performance,PerfThreshold.HighWatermark from NeConfig,SystemPerformance,PerfThreshold where PerfThreshold.PerfID=3 union select NeConfig.NeName,SystemPerformance.ID,SystemPerformance.Time,PerfThreshold.PerfID,SystemPerformance.Flow as Performance,PerfThreshold.HighWatermark from NeConfig,SystemPerformance,PerfThreshold where PerfThreshold.PerfID=4 union select NeConfig.NeName,SystemPerformance.ID,SystemPerformance.Time,PerfThreshold.PerfID,SystemPerformance.DiskUseRatio as Performance,PerfThreshold.HighWatermark from NeConfig,SystemPerformance,PerfThreshold where PerfThreshold.PerfID=5 union select NeConfig.NeName,SystemPerformance.ID,SystemPerformance.Time,PerfThreshold.PerfID,SystemPerformance.ProcessNum as Performance,PerfThreshold.HighWatermark from NeConfig,SystemPerformance,PerfThreshold where PerfThreshold.PerfID=6;
posted on 2007-03-27 16:49 鱼有所思 阅读(798) 评论(3)  编辑 收藏 引用 网摘 所属分类: PHP

评论:
# re: 我写过的最长的sql语句 2007-03-28 09:02 | zf
是够长的...不过结构还是很简单的...  回复  更多评论
  
# re: 我写过的最长的sql语句 2008-04-28 01:11 | liuxingyuyuni
no.....<<as>>.........  回复  更多评论
  
# re: 我写过的最长的sql语句 2008-06-04 11:02 | peng
使用别名应该短不少,呵呵  回复  更多评论
  

只有注册用户登录后才能发表评论。
网站导航: