该文被密码保护。 阅读全文
posted @ 2014-03-14 19:37 小鱼儿游 阅读(2) 评论(0) 推荐(0) 编辑
摘要: 1、使用where语句不推荐Select * from zflight.Check : zflight-airln = ‘LF’ and zflight-fligh = ‘BW222’.Endselect.推荐Select * from zflight where airln = ‘LF’ and fligh = ‘222’.Endselect.2、使用聚合函数不推荐Maxnu = 0.Select * from zflight where airln = ‘LF’ and cntry = ‘IN’.Check zflight-fligh > maxnu.Maxnu = zflight- 阅读全文
posted @ 2014-03-14 09:46 小鱼儿游 阅读(434) 评论(0) 推荐(0) 编辑