Special Functions in SQL

List Aggrigate Function
==================

This function will print the data of column into a single string using the seperator.

select listagg(ename,',') within group (order by 1) ename from emp 

Dense Rank()
============
This will provide the ranking for the coulumns

Eg:
===
SELECT empno, ename, sal,
DENSE_RANK() OVER(ORDER BY sal desc) toprank
FROM emp;   

Rank()

SELECT empno, ename, sal,
RANK() OVER(ORDER BY sal desc) toprank
FROM emp;