select a.e_id as e_id, a.e_name as e_name,
branch = (
case
when a.branch="bj" then "1"
when a.branch="xa" then "2"
when a.branch="sz" then "3"
when a.branch="dl" then "4"
when a.branch="cq" then "5"
when a.branch="yz" then "6"
when a.branch="ad" then "7"
else "3"
end)
from oe_table a,machine b,bank d
where ...
branch = (
case
when a.branch="bj" then "1"
when a.branch="xa" then "2"
when a.branch="sz" then "3"
when a.branch="dl" then "4"
when a.branch="cq" then "5"
when a.branch="yz" then "6"
when a.branch="ad" then "7"
else "3"
end)
from oe_table a,machine b,bank d
where ...
解决方案 »
- 请教一个关于分组增加序号的问题
- 疑惑
- 要做查询,用时间做范围,但是年月日都是变量。在SQL语句中怎么写???
- 存储过程中调用当前时间进行判断?? 当前时间怎样获得,请高手指点一下!多谢!
- sql server 2000 能装在windowsxp上吗?
- 分组后如何写返回与分组的相关其它字段。
- [轉] Transact-SQL Optimization Tips
- 关于哪位仁兄能公平的介绍一下PB????????????
- 如何选出表中某字段值为最大的那条记录???
- sql server中有没有与nolock关键字意思相反的关键字
- 关于存储过程!!!
- 请高手帮忙! 为何我的两个sql备份文件不能成功restore至sql server数据库中呢?
,a.e_name as e_name
,(
when case branch="bj" then "1"
when case branch="xa" then "2"
when case branch="sz" then "3"
when case branch="dl" then "4"
when case branch="cq" then "5"
when case branch="yz" then "6"
when case branch="ad" then "7"
else "3"
end) as branch
from oe_table a,machine b,bank d
where ...
(
case a.branch
when "bj" then "1"
when "xa" then "2"
when "sz" then "3"
when "dl" then "4"
when "cq" then "5"
when "yz" then "6"
when "ad" then "7"
else "3"
end) branch
from oe_table a,machine b,bank d
where ...