Soit le résultat visible dans la capture ci-dessous.
Quel est l'équivalent SQL de ce résultat ?

Question

Soit le résultat visible dans la capture ci-dessous. 
 Quel est l'équivalent SQL de ce résultat ?

Answer

SELECT DOI, Year, Detector FROM table t 
 WHERE CONTAINS(Detector,"tortured")>0 OR Year in (2018, 2020) 
 ORDER BY 2,1

Answer

SELECT DOI, Year, Detector FROM table t 
 WHERE CONTAINS(Detector,"tortured")>0 AND Year=2018 AND Year=2020 
 ORDER BY 2,1

Answer

SELECT DOI, Year, Detector FROM table t 
 WHERE CONTAINS(Detector,"tortured")>0 AND Year in (2018, 2020) 
 ORDER BY 1,2

Answer

SELECT DOI, Year, Detector FROM table t 
 WHERE CONTAINS(Detector,"tortured")>0 AND Year in (2018, 2020) 
 ORDER BY Year

Answer

SELECT DOI, Year, Detector FROM table t 
 WHERE CONTAINS(Detector,"tortured")>0 AND Year = (2018, 2020) 
 ORDER BY 2,1

Answer

SELECT DOI, Year, Detector FROM table t 
 WHERE CONTAINS(Detector,"tortured")>0 AND Year in (2018, 2020) 
 ORDER BY 2,1

Crowdly