Como nunca me acuerdo de la diferencia entre RANK() y DENSE_RANK(), me pongo este ejemplo para ver la diferencia: WITH employees AS (SELECT 10 AS department_id, ‘APELLIDO1’ AS last_name, 12 AS salary FROM dual UNION SELECT 10 AS department_id, ‘APELLIDO2’ AS last_name, 12 AS salary FROM dual UNION SELECT 10 AS department_id, ‘APELLIDO3’ AS last_name,…
Think Before You Write, Think Before You Talk, Think Before You Code, Think Before …