欢迎投稿

今日深度:

SQLite not in 无法查询数据,sqlitenot

SQLite not in 无法查询数据,sqlitenot


 

SELECT * FROM QuestionInfo
WHERE  ID != (select QuestionID from Exam)
SELECT * FROM QuestionInfo
WHERE  ID not in  (select QuestionID from Exam)

!= 有数据

not in 没有数据

但各类文档都说 2者是等价

www.htsjk.Com true http://www.htsjk.com/SQLite/25739.html NewsArticle SQLite not in 无法查询数据,sqlitenot   SELECT * FROM QuestionInfoWHERE ID != (select QuestionID from Exam) SELECT * FROM QuestionInfoWHERE  ID not in  (select QuestionID from Exam) != 有数据 not in 没有数据 但各类文档...
相关文章
    暂无相关文章
评论暂时关闭