3shTech

    3shTech (trainings@trishtechnology.com) String Functions Numeric Functions Group Functions Date Functions Conversion Functions Analytical Functions RANK , DENSE_RANK   SELECT employee_id,first_name,salary ,department_id       ,RANK() OVER (PARTITION BY department_id ORDER BY salary DESC) "Rank_emp"       ,DENSE_RANK() OVER (PARTITION BY department_id ORDER BY salary DESC) "Dense_Rank_emp"   FROM hr.employees   ORDER BY department_id;         LEAD , LAG   SELECT employee_id,first_name,salary ,department_id       ,LAG(salary) OVER (ORDER BY salary DESC) "Previous"       ,LEAD(salary) OVER (ORDER BY salary DESC ) "Next"   FROM hr.employees;         REGEXPR_SUBSTR   The regular expression matching information. It can be a combination of the following: Value Description ^ Matches the beginning of a string. If used with a  match_parameter  of &#