如题
季度倒数,参考下.
select * , rowNum-last(rowNum) as offset ,quarterEnd(end_date) as q from tradingday_rowno(2020.01.01,2021.01.01) context by quarterEnd(end_date) csort end_date