用sql 陳述句執行如何寫，表名為t1
uj5u.com熱心網友回復：
只知道這個用model 很簡單 但不會用,,,uj5u.com熱心網友回復：
month=row_number()over(parti by year order by year)
uj5u.com熱心網友回復：
SELECT * FROM(SELECT YEAR,MONTH,COUNT FROM t1 ORDER BY YEAR,MONTH) t
WHERE ROWNUM<=9
MODEL
DIMENSION BY (YEAR,MONTH)
MEASURES (COUNT)
RULES
(COUNT[2003,2]=COUNT[2002,2]+1,
COUNT[2003,3]=COUNT[2002,3]+1,
COUNT[2003,4]=COUNT[2002,4]+1)
ORDER BY YEAR,MONTH
uj5u.com熱心網友回復：
不行呀 提示這個錯誤，怎么處理
uj5u.com熱心網友回復：
select year,row_number() over(partition by year order by year) month,year-2000+row_number() over(partition by year order by year)*0.1 from t1uj5u.com熱心網友回復：
沒用
uj5u.com熱心網友回復：
全部都遞增了uj5u.com熱心網友回復：
SELECT YEAR, MONTH,DENSE_RANK() OVER(ORDER BY YEAR) || '.' || ROW_NUMBER() OVER(PARTITION BY YEAR ORDER BY MONTH)
FROM TABLE
uj5u.com熱心網友回復：
SELECT YEAR, ROW_NUMBER() OVER(PARTITION BY YEAR ORDER BY MONTH) AS MONTH,DENSE_RANK() OVER(ORDER BY YEAR) || '.' || ROW_NUMBER() OVER(PARTITION BY YEAR ORDER BY MONTH)
FROM TABLE
month 也根據年份分組,遞增
uj5u.com熱心網友回復：
有主鍵就好弄了，主要第9跟10剛不好區分
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/82486.html
標籤：基礎和管理
上一篇：Oracle日志中alert_orcl.log出現Fatal NI connect error 12170，如何破？