将一张表数据更新到另外一张表
- 场景说明:
update tbmk_gzp_detail
set tbmk_gzp_detail.f_bmbm = tbsys_bm.f_bmbm
from tbmk_gzp_detail
left join tbsys_bm on tbsys_bm.f_bmmc = tbmk_gzp_detail.f_bmbm
where tbsys_bm.f_bmbm<>''
对查询结果的某列的值进行去重。
- 场景说明:
SELECT f_khmc, f_zdrq
FROM (
SELECT ROW_NUMBER() OVER (PARTITION BY f_khmc ORDER BY f_zdrq DESC) AS id,*
FROM tbmk_ddzb
) n
WHERE n.id = 1
AND datediff(day, f_zdrq, getdate()) <= 20
ORDER BY f_zdrq DESC
字符串类型数字进行排序
- 场景说明:
- 方法一 加上一个数字,猜测是内部转换为数字。所以可以进行正常数字比较。
select
f_Sybm, f_Symc, f_zdrq<