pgsql 常用sql语句

1、查询重复记录:

  select * from admins_organizations
where  name in (select name from admins_organizations group by  name having count(name) > 1) 

2、查询重复记录，保留Id最小的值

 select * from admins_organizations
where  name in (select name from admins_organizations group by  name having count(name) > 1)  and
 id not in (select min(id) from   admins_organizations group by name  having count(name )>1)
order by name

3、去除空格

update from admins_organizations
set name=replace(name,' ','')
where id=34