oracle求指定时间连续天数
需求:得到指定时间开始往前数连续的天数,如id为a的数据对应时间:20200115,20200114,20200112,20200101,给定查询时间为20200115,则连续天数为2,一中断就终止
初始数据:
答案:
-- 部分数据
WITH T_AG_TOP_SYMBOLS AS (SELECT '20191024' AS UPDATE_DATE, '000158' AS TICKER_SYMBOL, 'XSHZ' AS EXCHANGE_CD, '常山北明' AS SYMBOL_NA.
原创
2020-06-29 16:58:58 ·
1147 阅读 ·
1 评论