Friday, April 4, 2014

Max Vs Greatest SQL


select greatest(50,20) from dual;

Output
50

select max(50,20,30) from dual;
Invalid number of arguments


select max(empno) from emp;

7934

select greatest(empno) from emp;


No comments:

Post a Comment