- SQL Function Limit differs in MYSQL and PostGreSQL
Script: SELECT e.ename , e.sal FROM emp e LIMIT 4 - Oracle equivalent is ROWNUM <= number
Script: SELECT e.ename , e.sal FROM emp e where ROWNUM <=4
query output:
Objective: LIMIT and RowNUM
|
| MYSQL Emp Table:
query output:
|
| ORACLE :
|
| PostgreSQL
|