SQL：postgresql

目录

• 1.Select语句
  • 1.Join on 多表联查
  • 2.In 多表联查
  • 3. inner 内连接
• 2.Update语句
  • 1.查询后更新
• DELETE语句
  • 1关闭限制后删除

1.Select语句

1.Join on 多表联查

SELECT
	c_bh_ft 
FROM
	FT.T_FT_YDXX
	JOIN msaj.t_ms_aj_jc ON ft.t_ft_ydxx.c_bh_aj = msaj.t_ms_aj_jc.c_bh 
WHERE
	c_bh_ft IS NOT NULL 
	AND ft.t_ft_ydxx.c_jbfy = '${jbfy}' 
	AND c_bh_ft != '${ajbh6}' 
	LIMIT 1

2.In 多表联查

SELECT * FROM db_ref.t_ref_code 
    WHERE c_pid 
    IN 
    (SELECT C_ID 
    FROM db_ref.t_ref_codetype WHERE c_id = '11401179' )

3. inner 内连接

      SELECT
	* 
      FROM
	ft.t_ft_ydxx
	INNER JOIN spzzcy.t_spzzcy_spzzcy ON ft.t_ft_ydxx.c_bh_aj = spzzcy.t_spzzcy_spzzcy.c_bh_aj 
	LIMIT 1;

2.Update语句

1.查询后更新

    UPDATE glaj.t_glaj_glgx AS glgx 
    SET d_larq = aj.d_larq,
    c_ah = aj.c_ah 
    FROM
    (
	SELECT
		aj.c_bh,
		aj.c_ah,
		aj.d_larq 
	FROM
		glaj.t_glaj_glgx glgx,
		xsaj.t_xs_aj_jc aj 
	WHERE
		( glgx.c_ah IS NULL OR glgx.d_larq IS NULL ) 
		AND LEFT ( glgx.c_ywlx, 2 ) = '02' 
		AND glgx.c_bh_aj = aj.c_bh 
	) AS aj 
	WHERE
	aj.c_bh = glgx.c_bh_aj;

DELETE语句

1关闭限制后删除

set abase.misopt_preventing = off;
commit;
set client_encoding = UTF8;
set search_path to spzzcy;
commit;
alter table t_spzzcy_spzzcybg drop column if exists c_bh_cbr;
alter table t_spzzcy_spzzcybg drop column if exists c_cbrbgyy;
set abase.misopt_preventing = on;
commit;