1 回答
- 最新
- 投票最多
- 评论最多
-1
The literal in the where clause is the problem. The query can't be parsed because there isn't a column named "nan".
Are you trying to check for null with "nan"?
The literal in the where clause is the problem. The query can't be parsed because there isn't a column named "nan".
Are you trying to check for null with "nan"?
Sorry, not sure I understand your question. Here's a query that gives the output that I expect. The WHERE clause has nothing to do with the rest of the query in the OP or in this example.