FREE AI-Enhanced Online PostgreSQL Compiler

Untitled*

You must execute the code again to save those values in the database.

CREATE TABLE testTable (
  test_time INT,
  test_value INT,
  test_part VARCHAR);
  
INSERT INTO testTable (test_time, test_value, test_part) 
VALUES 
(1,	30,	'sensor_C'),
(1,	40,	'sensor_D'),
(2,	11,	'sensor_A'),
(2,	21,	'sensor_B'),
(2,	31,	'sensor_C'),
(2,	41,	'sensor_D'),
(3,	10,	'sensor_A'),
(3,	20,	'sensor_B'),
(3,	40,	'sensor_D'),
(4,	11,	'sensor_A'),
(4,	20,	'sensor_B'),
(4,	30,	'sensor_C'),
(4,	41,	'sensor_D'),
(7,	11,	'sensor_A'),
(7,	29,	'sensor_C'),
(8,	10,	'sensor_A'),
(8,	19,	'sensor_B'),
(8,	29,	'sensor_C'),
(8,	40,	'sensor_D'),
(9,	39,	'sensor_D'),
(10, 9, 'sensor_A'),
(10, 20, 'sensor_B'),
(10, 30, 'sensor_C'),
(10, 40, 'sensor_D');

-- QUERY database

--DO $$
--DECLARE 
	--partCount INT
--BEGIN
	--SELECT COUNT(DISTINCT test_part) INTO partCount FROM testTable
--END $$

SELECT * FROM testTable
--WITH partCount AS(
  --SELECT COUNT(DISTINCT test_part) FROM testTable
  --SELECT COUNT(*) FROM (SELECT DISTINCT test_part FROM testTable) AS temp --Allegedly faster than SELECT COUNT(DISTINCT test_part) FROM testTable;
--)

--SELECT * FROM partCount CROSS JOIN testTable

test_time	test_value	test_part
1	30	sensor_C
1	40	sensor_D
2	11	sensor_A
2	21	sensor_B
2	31	sensor_C
2	41	sensor_D
3	10	sensor_A
3	20	sensor_B
3	40	sensor_D
4	11	sensor_A
4	20	sensor_B
4	30	sensor_C
4	41	sensor_D
7	11	sensor_A
7	29	sensor_C
8	10	sensor_A
8	19	sensor_B
8	29	sensor_C
8	40	sensor_D
9	39	sensor_D
10	9	sensor_A
10	20	sensor_B
10	30	sensor_C
10	40	sensor_D

CREATE TABLE
INSERT 0 24