I am starting a plugin connecting to PostGIS tables.In PostGIS I have a shapefile and a table. I get it the join of the two tables with this line:
SELECT * FROM layer INNER JOIN table ON layer.code = table.codeUntil here OK. But know I want to calculate the average values of the rows with the same characteristics. For example:
layer tableA 10A 10B 5B 10I want the median of the values in layer for A, B, .....
Can you help me please?Thanks.
أكثر...
SELECT * FROM layer INNER JOIN table ON layer.code = table.codeUntil here OK. But know I want to calculate the average values of the rows with the same characteristics. For example:
layer tableA 10A 10B 5B 10I want the median of the values in layer for A, B, .....
Can you help me please?Thanks.
أكثر...