PostgreSQL – Función PERCENT_RANK
En PERCENT_RANK() La sintaxis de la función PERCENT_RANK(): Syntax: PERCENT_RANK() OVER ( [PARTITION BY partition_expression, … ] ORDER BY sort_expression [ASC | DESC], … ) Analicemos la sintaxis anterior: PARTICIÓN POR ORDENAR POR PERCENT_RANK() CREATE TABLE product_groups ( group_id serial PRIMARY KEY, group_name VARCHAR (255) NOT NULL ); CREATE TABLE products ( product_id serial PRIMARY … Continue reading «PostgreSQL – Función PERCENT_RANK»