| Sql |
-- Note: Unless you save your query, these tabs will NOT persist if you clear your cookies or change browsers.
SELECT
MAX(a.loc_max) as locazione,
Max(a.compr_max) as quotazione,
a.data_storico,
nf.name,
nf.linkzona,
nf.codcom,
nf.codzona,
a.zona,
nf.name00,
nf.comune,
nf.shape_area,
nf.shape_leng
FROM public."v_agid_omi_ss_js" nf
Left Join (select * from public."Agid_VALORI_ss" where descr_tipologia in ('Uffici','Posti auto scoperti','Negozi','Capannoni industriali','Laboratori','Posti auto coperti','Box','Magazzini','Uffici strutturati','Centri commerciali') and stato='NORMALE') a ON a.zona=nf.codzona group by nf.codzona, a.zona,nf.name,
nf.linkzona,
nf.codcom,
nf.codzona,
nf.name00,
nf.comune,
nf.shape_area,
nf.shape_leng,
a.data_storico
|
