摘要： 查询最新一条 SELECT t.* FROM your_table t INNER JOIN ( SELECT type, MAX(created_at) as latest FROM your_table GROUP BY type ) t2 ON t.type = t2.type AND t.c 阅读全文

摘要： LAG(PUBLISHDATE, 1) OVER ( PARTITION BY b.FSYMBOL ORDER BY PUBLISHDATE) AS begin_date LEAD(PUBLISHDATE, 1) OVER ( PARTITION BY b.FSYMBOL ORDER BY PUBL 阅读全文

摘要： ROW_NUMBER() OVER ( PARTITION BY a.nav_date,b.level3id ORDER BY a.adjust_unit_nav asc) AS row_num 阅读全文

摘要： List<Integer> list2 = mapDemo.keySet().stream().collect(Collectors.toList()); --主键 List<Integer> list2 = mapDemo.values().stream().collect(Collectors. 阅读全文

摘要： import java.util.List; public class StdDevCalculator { public static double calculateStdDev(List<Double> numbers) { if (numbers.isEmpty()) { return 0; 阅读全文

摘要： package com.dc.galaxydata.model; import com.dc.common.util.DateUtil; import java.util.ArrayList; import java.util.Date; public class EndDates { public 阅读全文

摘要： package com.dc.galaxydata.model; import com.dc.common.util.DateUtil; import java.util.Calendar; import java.util.Date; public class DateLastEndUtil { 阅读全文

摘要： orcale 截取点后边的 SELECT SUBSTR(column_name, INSTR(column_name, '.') + 1) AS extracted_part FROM table_name; orcale 截取点前边的 SELECT SUBSTR(column_name, 0, I 阅读全文

摘要： WindowSpec windowSpec = Window.partitionBy("productCode", "taSystemCode").orderBy("remainVol");Dataset<Row> rowDataset = dataset.withColumn("序号命名", ra 阅读全文

摘要： 错误写法： <if test="salerCode != '*' "> AND a.saler_code = #{salerCode}</if> 正确写法： <if test='salerCode != "*" '> AND a.saler_code = #{salerCode}</if> 阅读全文