SQL 归纳

查询父节点的所有子节点：

SELECT * FROM menu m START WITH m.ID_ = '402882836068695f0160688eebf70006' CONNECT BY m.parent_id = PRIOR m.id_;

查询子节点的所有父节点：

SELECT * FROM menu m START WITH m.ID_ = '4028828360f8d01f0160f8d878d60009' CONNECT BY PRIOR m.parent_id = m.id_;

row_number() over()

ROW_NUMBER() OVER(PARTITION BY COLUMN1 ORDER BY COLUMN2)

意为：将表中的记录按字段 COLUMN1进行分组，按字段 COLUMN2 进行排序，同时新增一列为每组的排序号

 

获取日期的季度：

select to_char(to_date(occur_date, 'YYYY-MM-DD'), 'q') from dual;