WaterMelon 隨手記

Exception in thread "main" java.lang.Error: Unresolved compilation problem:

Unhandled exception type SQLException

at JavaName.main(JavaName.java:)

安裝jdk

vscode設定中java.Home加入如下:

"java.home": "/Library/Java/JavaVirtualMachines/jdk1.8.0_211.jdk/Contents/Home"

Java 介面化JFrame

Git初始化

新增Git

Select DISTINCT ItemId 
From Item

Select ItemId 
From Item
GROUP BY ItemId 

Select ItemId,CreatedDate 
From ( Select ItemId,CreatedDate , 
       ROW_NUMBER() Over (Partition By ItemId Order By CreatedDate Desc) As Sort From Item) TMP_S 
Where TMP_S.Sort=1