userimage

OVER clause in Oracle

What is the use of OVER clause in oracle.
userimage

The OVER clause specifies the partitioning, ordering of columns.

Ex: select e.*,row_number() over (order by sal ) from emp e;

Answer is