Re: [SQL ] 請教一個查詢語法....
看板Database (資料庫)作者daniel1205 (射手... 前進.)時間16年前 (2009/08/30 14:13)推噓0(0推 0噓 0→)留言0則, 0人參與討論串4/4 (看更多)
如果資料量不大的情況下可以考慮這種笨方法...
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
討論串 (同標題文章)
完整討論串 (本文為第 4 之 4 篇)：
Database 近期熱門文章
PTT數位生活區 即時熱門文章
