特殊功能的SQL语句

用于分层的sql

	select level,m.*
		from (select a.* from test a) m
		where 1=1
		start with m.col1 is null
		connect by prior m.col1 = m.col11 

其中col11为col1的上层关系

查詢每一分組的第n條數据

SELECT * FROM 
(SELECT A_TABLE.*,ROW_NUMBER() OVER (PARTITION BY COL1 ORDER BY COL2) THEROW FROM A_TABLE ) A
WHERE THEROW=n

其中COL1为分組字段，COL2为排序字段