1、将字符串转成数字
select sum(to_number(xq_total,'99G999D9S')) from food_basic_info_1_copy
2、修改字段类型
alter table food_xq_work_param_shinei alter COLUMN is_remote type varchar(100) ;
3、增加自增长的列
ALTER table 表名 add COLUMN _id BIGSERIAL primary key
4、删除列
ALTER table 表名 drop COLUMN _id BIGSERIAL primary key
5、查询记录数大于2的数据
select name
form ID
where name='name'
group by name having count(*) > 1
6、更新某个表的字段
UPDATE hospital_area_new_result_id_center A
set count = (
SELECT
total
FROM
hospital_area_new_work_param_center_4g_result_50 n
WHERE
A . ID = n. ID
)