12 2023 档案

sql: between and
摘要：microsoft sql server:SELECT * FROM ( SELECT t.*, ROWNUM rn FROM hr.bi_history t ) WHERE rn BETWEEN 5 AND 10;navicat sql server: select * from ( select 阅读全文
posted @ 2023-12-26 09:36 lixia64 阅读(20) 评论(0) 推荐(0)
子查询、Concat 字符拼接 ,Cast截取小数位 函数使用
摘要：select qh.CaseId ,(select sh.CaseId from ServiceQuot.dbo.Header sh where qh.QutoNo = sh.HeaderNo) ,qh.ApplierDate ,qh.BU ,qh.Site , qh.HeaderNo , qh.C 阅读全文
posted @ 2023-12-01 09:52 lixia64 阅读(38) 评论(0) 推荐(0)