Search Results

Showing results 1 to 1 of 1 Search took 0.00 seconds. Search: Posts Made By: binlib

Forum: Programming 03-07-2011

SQL - is it possible

2,046

Posted By

If you are using Oracle 10g or later, you can use...

If you are using Oracle 10g or later, you can use analytic functions like rank, mix and max.

1 select ename, sal, deptno
2 , decode(min(sal)over(partition by deptno), sal, 'MIN')
3 ,...

Showing results 1 to 1 of 1