heyRainbow的博客

工作中遇到了，随手记录下来 <insert id="insertByBatch" parameterType="java.util.List" useGeneratedKeys="false"> insert into FLTAC_FLIGHT_DETAIL ( PID, PLAN_ID, FLIGHT_N

UPDATE FLTAC_PLAN_DETAIL T1 SET ( ESTIMATED_SITE_HOUR_CONTR, ESTIMATED_CONTRIBUTE ) = ( SELECT SUM (ESTIMATED_SITE_HOUR_CONTR) AS ESTIMATED_SITE_HOUR_CONTR, SUM (ESTIMATED_CONTRIBUTE) AS ESTIMA...

ROWNUM 得到某次查询的第一行 SELECT t.* FROM TABLE_NAME t WHERE ROWNUM = 1; 得到第二行 SELECT * FROM ( SELECT ROWNUM ROW_NO, t.* FROM TABLE_NAME t ) temp WHERE temp.ROW_NO = 2 查询前10条 SELECT ROWNUM ROW_...