摘要: File excelFile = new File(path); if (!excelFile.exists()) { throw new Exception("The specified excel file does not exist at path: " + path); } // 使用Ea 阅读全文
posted @ 2024-03-28 11:23 丶Ronnie 阅读(1069) 评论(0) 推荐(0)
摘要: SELECT * FROM ( SELECT sc.*, jcl.*, ROW_NUMBER() OVER(PARTITION BY sc.id ORDER BY jcl.id DESC) as rn FROM A sc LEFT JOIN B jcl ON jcl.id = sc.id WHERE 阅读全文
posted @ 2024-03-28 10:26 丶Ronnie 阅读(19) 评论(0) 推荐(0)