SQLException: ORA-00936: missing expression
Code:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
| public static void nbreTassesMax() {
if (con == null)
getConnection();
try {
stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(("SELECT Programmeur, NbTasses FROM JoltData WHERE = (SELECT MAX(NbTasses) FROM JoltData)"));
while (rs.next()) {
System.out.println(rs.getString("Programmeur") + "a consommé" + rs.getInt("NbTasses"));
}
stmt.close();
} catch (SQLException ex) {
System.err.println("SQLException: " + ex.getMessage());
}
} |
Je ne trouve pas l'erreur :?
