Saturday, 28 June 2014

Oracle 12C New features Analytical Function Improvements same as MYSQL.

Analytical Function Improvements same as MYSQL.

Top-N feature
As like MySQL(limit clause), Oracle 12c will allow Top-N feature in
queries. Analytical function improvements.

Examples:

SELECT EMPNO,ENAME,DEPTNO FROM EMP ORDER BY SAL
FETCH FIRST 5 ROWS ONLY;




No comments:

Post a Comment