12 2021 档案

sql根据分组后排序取第一条数据
摘要：select * from(select *,ROW_NUMBER() OVER(PARTITION BY HAWB_NO,SUPPLIER_CODE ORDER By CREATE_DATE Desc) AS Row_Sortfrom SPECIAL_DNSEN.dbo.DNSEN_PLAN_I 阅读全文
posted @ 2021-12-22 10:50 饮水思源^0^ 阅读(2264) 评论(0) 推荐(0)
js 常用汇总
摘要：/** * 改变日期格式 *"2019/01/20 10:15:00"; */ function changeDateForm(endTime){//20190114195948 if(endTime.length != 14 ){ return ""; } var year =endTime.su 阅读全文
posted @ 2021-12-16 13:46 饮水思源^0^ 阅读(33) 评论(0) 推荐(0)
sql 多行拼接 成一行
摘要：--不去重 SELECT T1.DELIVERY_DATE,T.INNER_NO,stuff((SELECT '/'+CONT_2040 FROM SPECIAL_DNSEN.dbo.DNSEN_CONTAINER_NAME AS A WHERE A.INNER_NO=T.INNER_NO for 阅读全文
posted @ 2021-12-06 14:52 饮水思源^0^ 阅读(679) 评论(0) 推荐(0)