【ORACLE与mysql的区别】

1.sysdate

-- oracle
SELECT SYSDATE FROM DUAL

-- mysql
 SELECT SYSDATE() FROM DUAL

-- 语句3
SELECT SYSDATE() , LNS_END_DATE,SYSDATE() - LNS_END_DATE FROM MRS_CUST_LNS_DUE 

-- 语句4
SELECT CURDATE() , DATE(LNS_END_DATE),CURDATE() - DATE(LNS_END_DATE) FROM MRS_CUST_LNS_DUE 

上面语句3结果是不对的,需要改成语句4才可以

2.行号问题

MYSQL 没有rowner函数

-- mysql使用的语句是:
 SELECT B.content  FROM
  ( SELECT T.content FROM T1 T  WHERE T.text_type = 1 ORDER BY T.gmt_create desc   )  B   LIMIT 4

-- oracle的语句是:
 SELECT content  FROM
  ( SELECT T.content FROM T1 T   WHERE T.text_type = 1 ORDER BY T.gmt_create desc  )   WHERE ROWNER <4

3.日期问题TRUNC的替代

-- ORACLE
-- 获取月份第一天相等 TRUNC
		SELECT T2.BRANCH_NAME, T3.PROD_NAME,SUM(T1.VALID_NUM) C
		FROM MRS_ELCT_SUMMARY T1
		LEFT JOIN MRS_BRANCH T2 ON T1.BRANCH_ID = T2.ID
		LEFT JOIN MRS_ELCT_PRODUCT T3 ON T1.PRODUCT_ID = T3.ID
		WHERE  TRUNC(T1.DATA_DATE,'mm') = TRUNC(SYSDATE,'mm')
		GROUP BY T2.BRANCH_NAME, T3.PROD_NAME;

--MYSQL 没有TRUNC函数，年月相等与某年某月的第一天相等的含义是一样的
		SELECT T2.BRANCH_NAME, T3.PROD_NAME,SUM(T1.VALID_NUM) C
		FROM MRS_ELCT_SUMMARY T1
		LEFT JOIN MRS_BRANCH T2 ON T1.BRANCH_ID = T2.ID
		LEFT JOIN MRS_ELCT_PRODUCT T3 ON T1.PRODUCT_ID = T3.ID
		WHERE date_format(T1.DATA_DATE, '%Y%m') = date_format(CURDATE(), '%Y%m')
		GROUP BY T2.BRANCH_NAME, T3.PROD_NAME