说起sql语句,不仅仅是简单的增删改查,在工作中写的句子,总结下
INSERT INTO SELECT 先查询要添加的数据再将所有数据进行拼接 在执行插入,提高效率
INSERT INTO testN2.DFa
(SELECT Fa_C, CODE,‘20210907’, Fa_DT, Fa_ENDT,
Fa_ENTE, Fa_ENT, Fa_BID, Fa_OFFR, Fa_CHG,
Fa_NE, Fa_PRV, Fa_PR, Fa_BH_ID, Fa_AW_IN
FROM DFa WHERE Fa_PR = ‘20210928’ and Fa_C = ‘1111186’
AND CODE in (‘001’,‘003’,‘0007’))
** select 嵌套查询**
select * FROM 46.TD where P_ID,PO_CD in(
select P_ID,PO_CD from 41.TC ) and P_CD in (‘A’ ,‘C’);
关键字:like模糊查询、in、order by用于对结果集按照一个列或者多个列进行排序、desc升序
select p_id,P_CS_CD,SY_C_ID,P_IS_DT,S_A_ID,P_T_T, LA_AC_DT, PL_N_AC from 42.ptestwhere pan_id like ‘%eeeeeee%’ AND P_CS_CD IN (‘1’,‘3’,‘4’) and S_A_ID in (‘123’) order by P_IS_DT DESC