postgresql查询、更新语句

1、查询语句

select *  from tb_ymdd WHERE "ZZMS"='净种 净种'

select *  from tb_ymdd as t WHERE "ZZMS" ISNULL

2、更新语句

update tb_ymdd set "ZZMS"='其他' where "ZZMS" ='罗仁木' or "ZZMS"='2+3、2+2' or "ZZMS"='2+3 2+2';
update tb_ymdd set "ZZMS"='其它' where "ZZMS" ='净种 净种';

update tb_ymdd set "ZZMS"='其它' where "ZZMS" ISNULL;

3、唯一值查询

select Distinct "ZZMS" from tb_ymdd

4、删除换行

UPDATE tb_ymdd set "ZZMS" =REPLACE("ZZMS", CHR(10), '')

5、分组查询

select * from (
select *,row_number() over (partition by hz)idx from "fast_dcts" tb WHERE tb.timeslot BETWEEN '2021-07-01' and '2021-09-30 11:00:00' ORDER BY hz
)tmp WHERE idx=1

SELECT tb.hz, AVG(tb.value) FROM "fast_dcts" tb GROUP BY hz ORDER BY hz;