摘要：
一直以为rownum就是直接选出来排列的排序序号但是今天在做一个优先排序的时候发现自己错了select t1.* from ((SELECT DSCL_DATE_LIMIT, 0 AS STEP from DA_SET_CORP_LIMIT where DSCL_PATRON = '{0}' and DSCL_LOCATION_CD = '{1}') UNION (SELECT DSCL_DATE_LIMIT, 1 AS STEP from DA_SET_CORP_LIMIT where DSCL_PATRON is null and DSCL_LOCATION 阅读全文
