摘要:
格式:[SQL 语句 1]UNION[SQL 语句 2]对两个结果集进行并集操作,不包括重复行,同时进行默认规则的排序;select ID,NAME from AUNIONselect ID,NA... 阅读全文
摘要:
SELECT * fromCONNECT BY {PRIOR列名1=列名2|列名1=PRIOR列名2}[START WITH];Oracle的递归查询: START WITH :描述开始查询... 阅读全文
摘要:
SELECT TYEAR, MIN(TDATE) AS STARTDATE, MAX(TDATE), COUNT(TYEAR) AS ENDNUM --TYEAR年,STARTDATE连续记录的开... 阅读全文