(CASE WHEN Z_zhong > S_zhong
THEN convert(numeric(10,1),Z_zhong)
ELSE convert(numeric(10,1),S_zhong)
END)
as zhong,
THEN convert(numeric(10,1),Z_zhong)
ELSE convert(numeric(10,1),S_zhong)
END)
as zhong,
解决方案 »
- !!!!简单问题!~~~~~~~~~~~~~~~~~~~
- 网络小说站点,www.cnbooker.com,推荐给大家看看啊...
- 可不可以在客户端还原数据库,服务器的数据库权限应该怎样设置?
- SQL Server 2005 存储过程调用另一个存储过程,能否操作其返回的结果集???????
- 用ASP如何得到SQL Server存储过程的返回值并且同时得到返回的记录集?
- 又是一个SQL语句问题,可能偏点,请大家多指教
- Sql 取最近的时间
- 高分求解
- 菜鸟问题!关于修改表字段的默认值!
- 一个常见得查询问题
- 谁知道哪有 SQL SERVER 2000个人版下载,在线等....
- 求sql语句,去除重复数据
THEN CAST(Z_zhong AS Numeric(10,1),Z_zhong)
ELSE CAST(S_zhong AS Numeric(10,1),S_Zhong)
END)
AS zhong
----------------------------------------------------
(CASE WHEN Z_zhong > S_zhong
THEN convert(DEC(10,1),Z_zhong)
ELSE convert(DEC(10,1),S_zhong)
END)
as zhong
(CASE WHEN Z_zhong>S_zhong THEN CAST(Z_zhong AS Numeric(10,1),Z_zhong)
ELSE CAST(S_zhong AS Numeric(10,1),S_Zhong)
END) AS zhong
ELSE CAST(S_zhong AS Numeric(10,1))
END) AS zhong