神稚--OP舞又会成风潮？？|『动漫主题讨论区』

目的不明

级别: 骑士

注册时间:: 2006-10-14

在线时间:: 10小时

发帖:: 948

只看该作者 30楼发表于: 2008-10-07

引用
最初由 holyface 发布
舞蹈要流行起来首先需要节拍性强，其次需要连贯易于学习，这次神薙的OP华丽程度不减，但是明显两样都不具备，而且片子本身又不属于吐槽剧，那种热闹的带入感不足，不太可能火的起来。

你明顯就是在說涼宮嘛。

正體說，玫瑰即使改變了名字，她的芳香仍然不便
WITH T AS (SELECT (TO_DATE('20080101', 'YYYYMMDD') - 1 + LEVEL) AS DAY FROM DUAL CONNECT BY LEVEL <= (DATE'2108-12-31'-DATE'2008-01-01'))
SELECT year,DECODE(MOFY,TO_CHAR(DAY+(1-DOFW),'MM'),DECODE(SIGN((1-DOFW)),-1,NULL,TO_CHAR(DAY+(1-DOFW),'YYYYMMDD')),NULL) "1",DECODE(MOFY,TO_CHAR(DAY+(2-DOFW),'MM'),DECODE(SIGN((2-DOFW)),-1,NULL,TO_CHAR(DAY+(2-DOFW),'YYYYMMDD')),NULL) "2",DECODE(MOFY,TO_CHAR(DAY+(3-DOFW),'MM'),DECODE(SIGN((3-DOFW)),-1,NULL,TO_CHAR(DAY+(3-DOFW),'YYYYMMDD')),NULL) "3",DECODE(MOFY,TO_CHAR(DAY+(4-DOFW),'MM'),DECODE(SIGN((4-DOFW)),-1,NULL,TO_CHAR(DAY+(4-DOFW),'YYYYMMDD')),NULL) "4",DECODE(MOFY,TO_CHAR(DAY+(5-DOFW),'MM'),DECODE(SIGN((5-DOFW)),-1,NULL,TO_CHAR(DAY+(5-DOFW),'YYYYMMDD')),NULL) "5",DECODE(MOFY,TO_CHAR(DAY+(6-DOFW),'MM'),DECODE(SIGN((6-DOFW)),-1,NULL,TO_CHAR(DAY+(6-DOFW),'YYYYMMDD')),NULL) "6",DECODE(MOFY,TO_CHAR(DAY+(7-DOFW),'MM'),DECODE(SIGN((7-DOFW)),-1,NULL,TO_CHAR(DAY+(7-DOFW),'YYYYMMDD')),NULL) "7"
FROM(SELECT year,DAY,WOFM,WOFY,MOFY,DOFW,RANK() OVER(PARTITION BY year,MOFY,WOFY ORDER BY DOFW) AS SD FROM (SELECT to_char(day,'yyyy') year ,DAY,to_char(day,'W') AS WOFM,TO_CHAR(DAY+1,'IW') AS WOFY,TO_CHAR(DAY,'MM') AS MOFY,TO_CHAR(DAY,'D') AS DOFW FROM T))WHERE SD = 1 ORDER BY year,LPAD(MOFY,2,'0'),WOFm,wofy

回复引用

举报顶端

holyface