这里写自定义目录标题
例如我想把数据库存查询出的1 ,2 ,3 转换为一分厂,二分厂。三分厂。因为页面没做处理。
欢迎使用Markdown编辑器
SELECT
a.placename AS “placename”,
a.ds AS “dsCount”,
a.optime as optime,
( CASE
WHEN (a.factoryname = 1) THEN
‘一分厂’
WHEN (a.factoryname = 2) THEN
‘二分厂’
WHEN (a.factoryname = 2) THEN
‘三分厂’
end ) as factoryname
FROM
(select a.placename,a.optime,a.factoryname, COUNT(*) as ds FROM ce_bf_l_ex_t a
where
placename = '1'
AND factoryname = 1
GROUP BY a.placename,a.optime,a.factoryname) as a