为什么我不能对两行之间的所有数字求和?

Question

我正在尝试编写一个代码，将名为AMOUNT的列中的所有数据相加，该列在名为PERSON的表中名为DATA的列中的两行之间，我使用了sum函数，我使用了between函数 我收到以下错误：

java.sql.SQLSyntaxErrorException: Syntax error: 
Encountered "BETWEEN" at line 1, column 45.

代码 ：

private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {                                         
Connection con = null;
ResultSet rs = null;
PreparedStatement ps = null;
try {
String sql = "SELECT SUM(AMOUNT) AS SUMAMOUNT " +
"FROM PERSON BETWEEN DATE=? AND DATE=?";
con = DriverManager.getConnection("jdbc:derby://localhost:1527/Invoices",
"user1", "password");
ps = con.prepareStatement(sql);
ps.setString(1, jTextField1.getText());
ps.setString(2, jTextField2.getText());
rs = ps.executeQuery();
if (rs.next()) {
String sum = rs.getString("sumAmount");
jLabel3.setText(sum);
}
} catch(Exception ex) {
ex.printStackTrace();
}                                        
}

Answer 1

尝试这样的事情：

String sql = "SELECT SUM(AMOUNT) AS SUMAMOUNT FROM PERSON " + 
"WHERE (col_name) between '2020-05-01 00:58:26' " +
"and '2021-06-18 19:53:17'";