作者daniel1205 (射手... 前进.)
看板Database
标题Re: [SQL ] 请教一个查询语法....
时间Sun Aug 30 14:13:21 2009
如果资料量不大的情况下可以考虑这种笨方法...
CREATE VIEW V_AA_ROW
SELECT YYMM, 'PLUS_01' AS COL_NAME, PLUS_01 AS VAL FROM AA
UNION ALL
SELECT YYMM, 'PLUS_02' AS COL_NAME, PLUS_02 AS VAL FROM AA
UNION ALL
SELECT YYMM, 'PLUS_03' AS COL_NAME, PLUS_03 AS VAL FROM AA
UNION ALL
....
....
UNION ALL
SELECT YYMM, 'MIN_28' AS COL_NAME, MIN_28 AS VAL FROM AA
UNION ALL
SELECT YYMM, 'MIN_29' AS COL_NAME, MIN_29 AS VAL FROM AA
UNION ALL
SELECT YYMM, 'MIN_30' AS COL_NAME, MIN_30 AS VAL FROM AA
-----------------------------
SELECT COL_NAME
FORM V_AA_ROW
WHERE YYMM = 月份
AND VAL < 0
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 140.112.138.148