查询信息中最高的值 我要在查询出来的信息中提取最高的值并且显示出来SELECT id,COUNT(*) AS 峰值 FROM xl WHERE xl_name LIKE '%水%' AND time BETWEEN '2011-03-01' AND '2011-03-07' 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 WTITH ATE AS(SELECT id,COUNT(*) AS 峰值 FROM xl WHERE xl_name LIKE '%水%' AND time BETWEEN '2011-03-01' AND '2011-03-07' )SELECT MAX(峰值) FROM CTE select max(峰值) from (SELECT id,COUNT(*) AS 峰值 FROM xl WHERE xl_name LIKE '%水%' AND time BETWEEN '2011-03-01' AND '2011-03-07' )t select max(a.峰值) from(SELECT id,COUNT(*) AS 峰值 FROM xl WHERE xl_name LIKE '%水%' AND time BETWEEN '2011-03-01' AND '2011-03-07' )a WITH a AS 是什么意思? SQL 2005的新特性,CTE相当于一个临时表,内容暂时存放在里面,减少嵌套查询,直接通过CTE访问 WITH CTE AS(SELECT id,COUNT(*) AS 峰值 FROM xl WHERE xl_name LIKE '%水%' AND time BETWEEN '2011-03-01' AND '2011-03-07' GROUP BY ID)SELECT MAX(峰值) FROM CTE 请教一个排序问题 创建多表关联的视图问题 问两道问题: 请教sql语句 激活EXEC sp_tableoption 'ygda', 'text in row', '2000'无效问题 请问那本sql server的书好? 请教一个数据库的问题100f 关于数据库连结的一个问题,欢迎大家指点讨论~~~ 数据库恢复时出现【不能获得数据库的排他访问权】? 如何设计一个流量套餐 事务的“一致性”怎么理解??? 修改表出错
WTITH ATE AS
(
SELECT id,COUNT(*) AS 峰值 FROM xl WHERE xl_name LIKE '%水%' AND time BETWEEN '2011-03-01' AND '2011-03-07'
)
SELECT MAX(峰值) FROM CTE
max(峰值)
from
(SELECT id,COUNT(*) AS 峰值 FROM xl WHERE xl_name LIKE '%水%' AND time BETWEEN '2011-03-01' AND '2011-03-07' )t
select max(a.峰值) from
(
SELECT id,COUNT(*) AS 峰值 FROM xl WHERE xl_name LIKE '%水%' AND time BETWEEN '2011-03-01' AND '2011-03-07'
)a
WITH CTE AS
(
SELECT id,COUNT(*) AS 峰值 FROM xl WHERE xl_name LIKE '%水%' AND time BETWEEN '2011-03-01' AND '2011-03-07' GROUP BY ID
)
SELECT MAX(峰值) FROM CTE