vincentdesmares · May 12, 2017 00:39
diff --git a/window-function-6.sql b/window-function-6.sql
 CREATE TABLE employe AS (
  SELECT
    n                                          AS id,
    'Employe name' || n                        AS name,
    trunc(random() * 9000 + 1000)              AS salary,
    chr((65 + trunc(random() * 5)) :: INTEGER) AS category
  FROM
        generate_series(1, 5000, 1) AS n
 );
	CREATE TABLE employe AS (
	SELECT
	n AS id,
	'Employe name' \|\| n AS name,
	trunc(random() * 9000 + 1000) AS salary,
	chr((65 + trunc(random() * 5)) :: INTEGER) AS category
	FROM
	generate_series(1, 5000, 1) AS n
	);